Help needed with Joining 2 Queries together

[neilsytner]

hi all.

i've got the following two queries and i'd like to combine them into one, and
i just can't figure it out. hoping someone here can get the old grey-matter
working again :)

basically i would like to display the dealerName (from the 1st query) that is
equal to the dealerID (in the 2nd query).

hope this makes sense!

thanks in advance for any replies.

regards,

Neil



<cffunction name="GetDealers" access="public" output="false"
returntype="query" hint="Get current list of dealerships.">
<cfset var qGetDealers = "" />
<cfquery name="qGetDealers" datasource="#variables.dsn#">
SELECT dealerID,
dealerName
FROM tblDealers
ORDER BY dealerName DESC
</cfquery>
<cfreturn qGetDealers />
</cffunction>

<cffunction name="GetOrderSummaries" access="public" output="false"
returntype="query" hint="Get current summary list of orders.">
<cfset var qGetOrderSummaries = "" />
<cfquery name="qGetOrderSummaries" datasource="#variables.dsn#">
SELECT orderID,
orderDateTime,
customerID,
dealerID,
orderNoCustomer
FROM tblOrders
ORDER BY orderDateTime DESC
</cfquery>
<cfreturn qGetOrderSummaries />
</cffunction>

[neilsytner]

figured it out...

<cffunction name="GetOrderSummaries" access="public" output="false"
returntype="query" hint="Get current summary list of orders.">
<cfset var qGetOrderSummaries = "" />
<cfquery name="qGetOrderSummaries" datasource="#variables.dsn#">
SELECT O.orderID,
O.orderDateTime,
O.customerID,
O.dealerID,
O.orderNoCustomer,
D.dealerID,
D.dealerName
FROM tblOrders AS O,
tblDealers AS D,
WHERE O.dealerID = D.dealerID
ORDER BY O.orderDateTime DESC
</cfquery>
<cfreturn qGetOrderSummaries />
</cffunction>