Thanks Elena, I tried it in this way, and the result was same, it didn't work. any otherway to run the query, which give me the distinct value, i.e. QoQ?
Thanks ><CFQUERY DATASOURCE="#DSN#" NAME="TestQuery"> >Select distinct state, city, name from list ></CFQUERY> > >Or try the select distinct * from list > >Elena >-----Original Message----- >From: Asim Manzur [mailto:[EMAIL PROTECTED] >Sent: Monday, June 06, 2005 12:19 PM >To: CF-Talk >Subject: Re: ThreeSelectRelated Distinct value > >I know this is just a matter to write the query. >Can someone help me to sort this out? > > >-- >Regards, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
