Two queries from different tables.
Query1: Select myDATA from myTABLE
Query2: Select myDATA2 from myTable2 WHERE prodID NOT IN (#ValueList(Query1.prodID)#)
But that's throwing an error. prodID is not numeric, so that's perhaps the problem. Can't seem to get the syntax just right though...
Pointers?
-- ----------- Les Mizzell
---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
