Skip to Content
0
Feb 20, 2009 at 08:19 AM

Query for Customer Related Activities

30 Views

What is the error with this sql statement

T0.[CardCode], T0.[CardName], T0.[GroupCode], T0.[Address], T0.[ZipCode], T0.[Phone1], T0.[Phone2], T0.[Fax], T1.[Notes] from OCRD T0 INNER JOIN OCLG T1 ON T0.CardCode = T1.CardCode where T0.[CardCode] =[%0] Group by T0.[CardCode]

Actually I wanted a report displaying all the related activities for a selected business partner.

it is giving me the error like [Microsoft][SQL Native client][sql Server] column 'OCRD.CardName' is invalid in the select list because it is not contained in eiother an aggregate function or the etc.

thanks

SV Reddy