Hi all
I wrote this query:
SELECT
<!--- COUNT(loc.drawing_ID) AS print_qty, --->
dwg.drawing_ID,
dwg.drawing_number,
dwg.title_uprr,
dwg.title_secondary,
rel.related_type
FROM
uprr_related_drawings rel,
uprr_drawings dwg
LEFT JOIN
uprr_dateloc loc
ON
dwg.drawing_ID = loc.drawing_ID
WHERE
rel.drawing_ID = #current_drawing_ID#
AND
dwg.drawing_ID = rel.related_drawing_ID
AND
rel.related_type = 'detail'
And recieve the following error when I try to run the page:
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.
Would this work in MS SQL 7? How would I do this in Access SQL?
Thanks!
* John *
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
