Hi,
Is this OK for a SQL query? The 2 tables in question are categories and
sub_categories. Everything seems ok, but it's not working..
<cfquery name = "cats" datasource = "localads">
Select categories.ID, categories.cat_name, sub_categories.sub_id,
sub_categories.sub_name, sub_categories.sub_descript
FROM categories,sub_categories
WHERE sub_categories.cat_id = categories.ID
</cfquery>
Thanks,
Will
--
Lukrative Media Ltd - Berkshire, UK
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.