> Has anyone pulled data from one of two tables using "DISTINCT" ?
Try this... make sure both tables have the same number of columns if you use
SELECT *
<CFQUERY NAME="statusNew" DATASOURCE="databasename">
SELECT busPlan.*
FROM busPlan
WHERE status LIKE "new"
UNION DISTINCT
SELECT entreProfile.*
FROM entreProfile
WHERE status LIKE "new"
</CFQUERY>
Marc
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
