Thank you Dave and everyone for responding so promptly!!! gotta get the order of the statement....
it works now, and I get my $35... Julia Computer Consulting Web Design @ Reasonable Prices PO Box 279 Watertown MA 02471-0279 Email: [EMAIL PROTECTED] http://www.juliagreen.com Phone: 617-926-3413 Fax: 617-812-5935 ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 04, 2001 10:52 AM Subject: RE: Important - For a project -- please help > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
