Column value if table exists otherwise original table

[badlhby]

I must be having a brain fart here... I can't seem to figure out the structure for this...

 

I have 2 tables products and products_locations... values know are products_id and locations_id

 

Table products_locations may not have an entry for products_id

 

I am trying to formulate a query which returns products_price and products_quantity from table products_locations if available otherwise from table products.

 

SELECT products_price, products_quantity FROM products WHERE products_id = :pID;

 

SELECT products_price, products_quantity FROM products_locations WHERE products_id = :pID AND locations_id = :lID;

 

Any assistance would be appreciated

 

[Barand]

you need a left join between the tables and use IFNULL() to show the desired values