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