Add 2 mysql_queries results

[nobru]

Hi there,

For some reason, I have two product tables which have exactly the same fields.
Table Products1 -> ID, name, description
Table Products2 -> ID, name, description

I would like to be able to run a query on both tables at the same time.
I tried something like « SELECT p.id, p2.id FROM products p, products2 p2 » but I dont get the expected results.

What I would like to do is to make 2 different queries:
$query1 = mysql_query(« SELECT id FROM products ») ;
$query2 = mysql_query(« SELECT id FROM products2 ») ;

But now how to combine these 2 queries so that I can run the mysql_fetch_array() function on both queries at the same time ?
Is there a way to « add » these 2 queries ?

Thanks in advance
Bruno

PS : I did the following which works :
while ($array = mysql_fetch_array($query1) OR $array = mysql_fetch_array($query2)){
…
}
BUT I need to combine both queries BEFORE…

[jpmoriarty]

if you do a join (which you've done by giving two tables to the FROM bit of the query) then you've got to tell Mysql where the join is. So for example, if the id numbers are the same, then you'd do:

$sql = "select * from products, products2 where products.id = products2.id";

[nobru]

Hi,
the problem is that the product IDs are not the same.
So I cannot use such a statement: "where products.id = products2.id".
I also tried "where products.id != products2.id", but it does not work.

What I need is to select DISTINCT p.id AND p2.id...

Any other idea? 😕

[jpmoriarty]

i think the only way you can do it is the way you've done it above - you're not actually joining the tables, so that won't do it.

[nobru]

Yep, indeed...
I've actually found a workaround by creating 1 products table (with the 2 other's data) and adding a column to specify to which "old" product table it belonged...
That's much more simple this way 🙂
Thank you for your contribution 🙂