|
|
Posted by laredotornado on 02/24/06 00:48
Hello,
Not sure what an outer join query is, but would it apply here? How
would I write a query, given these two tables and data
CATEGORIES
--------------------
CATEGORY_ID
1
2
PRODUCTS
-----------------
PRODUCT_ID CATEGORY_ID SALE_PRICE
A 1 NULL
B 1 13.50
C 2 NULL
I would like to write a single MySQL query to indicate that a category
has at least one product with a non-null sale price but also return a
result for the categories that don't. Ideally, with the above data, my
result set would look like
CATEGORY_ID HAS_SALE
1 Yes
2 No
Any ideas how I can do this? Using MySQL 4, PHP 4. Thanks, - Dave
Navigation:
[Reply to this message]
|