Hi, all.
This query worked with MS Access, but not with MySQL...
How should I change this to make it work?
Is it a subquery problem?
This is MySQL version 4.0.5 beta...
<CFQUERY Name="GetUnit" Datasource="#DSN#">
Select * from Units U where U.UnitID
in (Select UnitID from Clients where Clients.ClientID
= #App_ClientID#)
</CFQUERY>
Thanks!
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
