SELECT
c.contactname AS [CONTACT NAME],
c.firstname AS [FIRSTNAME],
c.midname AS [MIDDLE NAME],
c.surname AS [SURNAME],
c.adr1 AS [ADDRESS 1],
c.adr2 AS [ADDRESS 1],
c.adr3 AS [ADDRESS 1],
c.state AS [STATE],
c.country AS [COUNTRY],
c.postcode AS [POSTAL CODE],
c.email AS [EMAIL],
CONCAT(ISNULL(LTRIM(RTRIM(c.Phone1CountryCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.Phone1AreaCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.Phone1)), ''), ' ' )
AS [CONTACT PHONE 1],
CONCAT(ISNULL(LTRIM(RTRIM(c.Phone2CountryCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.Phone2AreaCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.Phone2)), ''), ' ' )
AS [CONTACT PHONE 2],
CONCAT(ISNULL(LTRIM(RTRIM(c.CellCountryCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.CellAreaCode)), ''), ' ',
ISNULL(LTRIM(RTRIM(c.Cell)), ''), ' ' )
AS [CONTACT CELL]
FROM tblcontact c
LEFT OUTER JOIN tbllinkcustcontact L
ON C.id = L.contactid
LEFT OUTER JOIN tblvenues V
ON C.id = V.contactid
LEFT OUTER JOIN tblcust T
ON L.customer_code = T.customer_code
LEFT OUTER JOIN tblsalesper
ON c.salesperson_code = tblsalesper.salesperson_code
INNER JOIN tblInvMas IM ON C.ID = IM.ContactID ORDER By c.Contactname