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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
