> 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 > WHERE status LIKE "new" > </CFQUERY>
arun, could you please indicate which distinct value you want, and why you think you couldn't just select from the busPlan table alone? no sense involving a second table if you don't need to you indicated that you already did this to one table > SELECT COUNT(DISTINCT profileID) AS new > FROM busPlan > WHERE status LIKE "new" and i'm curious why this doesn't work, because this is the syntax you need, according to your explanation -- "I'd like to pull the DISTINCT value from the table busPlan only" rudy http://rudy.ca/ - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[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)
