Skip to Content
0
Apr 27, 2011 at 05:50 AM

Query Report Issue

26 Views

Hi Experts,

Plz check this query, I generate this query for BP Master Details but it returns double master( one name two time).

SELECT distinct T0.[CardCode], T0.[CardName], T2.[Address], T2.[Street], T2.[Block], T2.[City], T2.[State], T2.[ZipCode], T1.[Name], T1.[Position], T1.[Address], T1.[Cellolar], T1.[Tel1], T1.[Tel2], T1.[Fax], T0.[E_Mail], T0.[IntrntSite], T3.[ECCNo], T3.[TaxId0] As 'PAN No.', T3.[TaxId1] As 'CST No.', T3.[TaxId2] As 'LST No.', T3.[TaxId3] As 'Service Tax No.', T3.[TaxId6] As 'TAN No.', T3.[TaxId10] As 'TIN No.', T0.[DflAccount] As 'Bank A/c. No.', T0.[DflBranch] As 'Branch Code', T0.[BankCode] As 'Bank Name' FROM OCRD T0 INNER JOIN OCPR T1 ON T0.CardCode = T1.CardCode INNER JOIN CRD1 T2 ON T0.CardCode = T2.CardCode INNER JOIN CRD7 T3 ON T0.CardCode = T3.CardCode

where t0.cardtype = 's'

Plz help.

Regards,

Ravi