You need to join these tables some how.
<snip...>
SELECT CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID,
CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE CLIENTS.CLIENT_NAME='#session.client#'
</snip>
Add something like the following:
AND products.prod_id = category.prod_id
It's hard to know how you're really need to do it without knowing how your
tables are set up, but I'm assuming you must have some relationships between
these three tables. Reference the relationship in your query with where
statements.
Hope that helps.
-Deanna
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
------------------------------------------------------------------------------
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.