Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:45:53
|
Jonathan writes "I am trying to return a count of the records returned from a query that joins three tables and selects some records from the join. Every time I use the COUNT statement, I get a syntax error. For example, the following SQL statement gives me a complaint about an error in the FROM clause:
SELECT COUNT(*) As Count FROM (SELECT job.*, photo_sheets.*, Path.Path FROM Path LEFT JOIN (photo_sheets LEFT JOIN job ON photo_sheets.[PHO_JOB#] = job.[PHO_JOB#]) ON Path.FileName = photo_sheets.FILE_NAME WHERE ((Not (photo_sheets.NORTHING) Is Null) AND (Not (photo_sheets.EASTING) Is Null) AND ((Path.t8dbase)=True) AND (job.[CO] = 'SBd') AND (job.[RTE] = 10) AND ((photo_sheets.[SheetBPM] BETWEEN 10 AND 11) OR (photo_sheets.[SheetEPM] BETWEEN 10 AND 11) OR (photo_sheets.[SheetBPM]<=10 AND photo_sheets.[SheetEPM]>=11))
Here is the basic SELECT statement I am trying to count the records from:
SELECT job.*, photo_sheets.*, Path.Path FROM Path LEFT JOIN (photo_sheets LEFT JOIN job ON photo_sheets.[PHO_JOB#] = job.[PHO_JOB#]) ON Path.FileName = photo_sheets.FILE_NAME WHERE ((Not (photo_sheets.NORTHING) Is Null) AND (Not (photo_sheets.EASTING) Is Null) AND ((Path.t8dbase)=True) AND (job.[CO] = 'SBd') AND (job.[RTE] = 10) AND ((photo_sheets.[SheetBPM] BETWEEN 10 AND 11) OR (photo_sheets.[SheetEPM] BETWEEN 10 AND 11) OR (photo_sheets.[SheetBPM]<=10 AND photo_sheets.[SheetEPM]>=11)
Thanks in advance for any help. Windows Version: NT Server 4.0
Service Pack 6, IIS 4.0 performs SQL queries." |
|
|
|
|
|
Counting records returned from a join query