[SOLVED] help with two tables

[syntax101]

my problem is i want to display all data  that has a "rejected", i have two tables orders and archivedeletedorders and they have all the same fields.

 

 

ex.

 

orders table

name    status  <-fields

henry    pending

squall    rejected

 

 

archivedeleteorders table

name    status  <-fields

philip    pending

john    rejected

 

 

result should be:

 

name    status

squall    rejected

john    rejected

 

my code is:

select * from orders,archivedeletedorders where orders.del_status = "Rejected" and archivedeletedorders.del_status = "Rejected"

 

but the result will combine them like this:

 

name    status      name    status

squall    rejected  john    rejected

 

can anybody help me with this

[Barand]

You need a UNION, not a JOIN

 

SELECT name, status FROM orders WHERE status = 'rejected'
UNION
SELECT name, status FROM archivedeletedorders WHERE status = 'rejected'

[syntax101]

thanx a lot, i forgot to use UNION