PROTECTED] On Behalf
> Of Khush
> Sent: Wednesday, 12 November 2008 9:02 AM
> To: cfaussie
> Subject: [cfaussie] Referencing a query inside another query in ColdFusionMX
>
>
> How do i reference a field (SalesHDRID) from a query (called
> SelectedOrders) in the where conditio
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 Selected