Skip to Content
0
Former Member
Nov 01, 2013 at 05:51 AM

Query Not Providing Output

17 Views

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]