Query Not Providing Output

[Former Member]

SELECT T1.[CardCode] AS 'BP Code', T1.[CardName] AS 'BP Name', T1.[CardFName] AS 'Foreign Name', T0.[Address] AS 'Address Name', T0.[Building] AS 'Building/Floor/Room', T0.[Block] AS 'Block', T0.[Street] AS 'Street', T0.[City] AS 'City', T0.[County] AS 'County', T0.[State] AS 'State', T0.[Country] AS 'Country', T0.[ZipCode] AS 'Zip Code', T2.[Tel1] AS 'Telephone 1', T2.[Tel2] AS 'Telephone 2', T2.[Cellolar] AS 'Mobile Phone', T2.[Fax] AS 'Fax', T2.[E_MailL] AS 'E-Mail', T3.[TaxId0] AS 'PAN', T3.[TaxId1] AS 'CST', T3.[TaxId2] AS 'VAT No.', T3.[TaxId4] AS 'Tax ID 4', T3.[TaxId10] AS 'Tax ID 10', T3.[TaxId11] AS 'TIN' FROM  [dbo].[CRD1] T0  INNER  JOIN [dbo].[OCRD] T1  ON  T1.[CardCode] = T0.[CardCode]   INNER  JOIN [dbo].[OCPR] T2  ON  T2.[CardCode] = T1.[CardCode]  ,  [dbo].[INV12] T3  INNER  JOIN [dbo].[OCRD] T4  ON  T4.[CardCode] = T3.[Carrier]

[kothandaraman_nagarajan]

Hi,

try this:

SELECT T1.[CardCode] AS 'BP Code', T1.[CardName] AS 'BP Name', T1.[CardFName] AS 'Foreign Name', T0.[Address] AS 'Address Name', T0.[Building] AS 'Building/Floor/Room', T0.[Block] AS 'Block', T0.[Street] AS 'Street', T0.[City] AS 'City', T0.[County] AS 'County', T0.[State] AS 'State', T0.[Country] AS 'Country', T0.[ZipCode] AS 'Zip Code', T2.[Tel1] AS 'Telephone 1', T2.[Tel2] AS 'Telephone 2', T2.[Cellolar] AS 'Mobile Phone', T2.[Fax] AS 'Fax', T2.[E_MailL] AS 'E-Mail', T3.[TaxId0] AS 'PAN', T3.[TaxId1] AS 'CST', T3.[TaxId2] AS 'VAT No.', T3.[TaxId4] AS 'Tax ID 4', T3.[TaxId10] AS 'Tax ID 10', T3.[TaxId11] AS 'TIN' FROM  [dbo].[CRD1] T0  left  JOIN [dbo].[OCRD] T1  ON  T1.[CardCode] = T0.[CardCode]   left  JOIN [dbo].[OCPR] T2  ON  T2.[CardCode] = T1.[CardCode] left join   [dbo].[INV12] T3  ON  T2.[CardCode] = T3.[Carrier]

Thanks & Regards,

Nagarajan