Select from two tables

[abdelelbouhy]

Hi guys,

i have two tables products and deleted_products i want to select products_id from the two tables where the field suspend = 1 but there's no relationship between the tables in other words i want all the products_id from the tables where suspend = 1 but the products_id in table one doesn't match produtcs_id in table 2 the only relationship i can find is the suspend in both tables is 1

 

 

my query string is like that

 

select p.products_id as PID, dp.products_id AS PDID FROM products p, deleted_products dp WHERE p.suspend = dp.suspend and p.suspend = 1

 

it return zero result but the two tables have products with suspend = 1

 

thanx

Edited August 7, 2013 by abdelelbouhy

[niche]

No relationship (between your tables) = no join with sql. However, you can select both tables with two different queries and combine their results with PHP.

Edited August 7, 2013 by niche

[justsomeguy]

Use a union, that's what they're for.

 

SELECT product_id FROM table1 WHERE suspend=1 UNION SELECT product_id FROM table2 WHERE suspend=1