> The order of your statements is incorrect. It should be... > > SELECT count(t.File) as file3, g.File, t.File > FROM tblfile t, gilway12 g > WHERE t.File=g.File > GROUP BY g.File
In the GROUP BY clause, you'll need to include all columns listed in the SELECT: GROUP BY g.File, t.File Of course, since g.File and t.File are identical values, you probably don't need both of them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
