Make you complicate query a database view
On 12/11/2008, Khush <[EMAIL PROTECTED]> wrote: > > > How do i reference a field (SalesHDRID) from a query (called > SelectedOrders) in the where condition of another query. > > My CF query looks somewhat like this- > SELECT salesdetail.packerid > FROM SALESDETAIL > WHERE SALESDETAIL.SalesHDRID IN (SelectedOrders.SalesHDRID) > > Now my query SelectedOrders is a really big and very complicated one, > so I am not going to just paste it in the IN clause...If anyone has > any ideas how to actually reference this sub query by it;s name in the > main query above, please let me know ASAP as i need this urgently... > > > THanks > > > -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---