Hello,
I left my SQL in 10 Minutes book at the office, so sorry for the OT Post....
I have two tables "subscriber_ads" and "book_details"
I need to get all the info out of "book_details" and one column,
"ad_contact" out of "subscriber_ads". The common columns are "ad_id" and
"subid"
book_details
ad_id
subid
author
title
notes
subscriber_ads
ad_id
subid
ad_contact
"SELECT book_details.*, subscriber_ads.ad_contact FROM book_details,
subscriber_ads"
Returns a cartesian (if I remember my DB class correctly) join
I'm thinking I need to do an Inner Join, but I can't remember how the syntax
goes. Anyone have a suggestion?
Thanks,
James
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
