View Single Post
Old 11-28-2003, 03:54 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Hi. The sites.account_id = clients.id portion would go in the WHERE portion of the query, and you'd need to add the table clients into the FROM portion of the query.

The query you are editing uses results from the previous query so you may want to edit that previous query instead and then just select sites.account_id in the query you are currently editing.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote