On Thursday, December 17, 1998 12:48 PM, [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] wrote: > select a.CrossID, a.Name, a.LandScape, count(b.CrossID) as CountFld > from ctabhed a left join ctabdat b on a.CrossID = b.CrossID > group by a.CrossID, a.Name, a.LandScape Looks likes it working anyway :) *yay* --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
- RE: [DUG]: SQL Problem..... urgent answer required... Derricutt, Mark