Re: MySQL query question ...

["Al Wheeler-2" <user=1343@nabble.blu.org>]

 ref wrote: 

> 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 
> 
> 
>