Has anyone pulled
data from one of two tables using "DISTINCT" ?
I've done it on one
table:
<CFQUERY
NAME="statusNew" DATASOURCE="databasename">
SELECT COUNT(DISTINCT profileID) AS new
FROM busPlan
WHERE status LIKE "new"
</CFQUERY>
SELECT COUNT(DISTINCT profileID) AS new
FROM busPlan
WHERE status LIKE "new"
</CFQUERY>
But I'd like
to pull the DISTINCT value from the table "busPlan" only and not "entreProfile" table.
<CFQUERY
NAME="links" DATASOURCE="biobroker">
SELECT busPlan.*, entreProfile.*
FROM busPlan, entreProfile
SELECT busPlan.*, entreProfile.*
FROM busPlan, entreProfile
WHERE status LIKE
"new"
</CFQUERY>
</CFQUERY>
I just can't figure
out the correct syntax.
Thank you for any
assistance out there.
Arun Persaud
