Hi folks,
dont know if this is the correct place for this, but I was wondering if
there are any MySQL gurus out there who could help me with this.
Problem :
I want to select contents from "table aay", but only if it has
relational records in "table bee" OR relational records in "table cee"
Rationale :
I have a store table, called "store_details". I want to be able to pick
a random store from the store details table. However, as I dont want to
display an empty or unready store, so I want to check and see if that
store has items in it. These items can be stored in either of two
tables, depending on the product being sold.
Both product_table_two and product_table_one have the store_id key from
store_details.
So, in part-pseudo code it would look like :
SELECT * FROM
store_details ,
product_table_one,
product_table_two,
WHERE store_id >= (SELECT FLOOR( MAX(store_id) * RAND()) FROM
page_details )
and
BOTH (product_table_one AND Product_table_two) are NOT EMPTY ...
ORDER BY so_store_id LIMIT 1
I just dont see how to get the 'either or' part going ...
Can anyone help me ?
thank you in advance,
Richard
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
Discuss mailing list
Discuss@...
http://lists.blu.org/mailman/listinfo/discuss
blu.org wiki
