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
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct
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
The only dumb questions are the ones not asked!
hehehe, I don't know the answer though sorry. :-(
Mike
- Original Message -
From: Julia Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 10:29 AM
Subject: Important - For a project -- please help
-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
4 matches
Mail list logo