SELECT from two Tables.

[RDx321]

Guys I need some help. I have to tables, orders1 and orders2

I would like to display the data from both of those tables with just one query. I found articles on using JOIN. But I don't have any ID that's exactly the same on both of them. All the data is unike to each table with nothing linking each of them.

orders2 has two additional columns that orders1 does not have.

Once I get the data I want to sort it by Date and only get 80 records from each table.

Whats the best way to do this?

Thank you.

[CoderDan]

You'll need to tell us what exactly kind of data you want to get from your query.
it would help if you could, say, provide the 2 table's structures, and show what kind of array you expect to get from the result of the query.

[djjjozsi]

you should re-desing your tables to able to store the two tables in one, if they're storing the same information. If you see that you need to duplicate rows to add new values into a record:

for example:

orders_table
email , itemname,quantity , orderdate
[e-mail]  , plane  , 4  , ____-__-__
[e-mail]  , plane  , 3  , ____-__-__
xcvxcv@asdélkasd.com , plane , ____-__-__

in this horrible table the emails and items are duplicated. You should store the items and emails in two separated table, meanwhile the orders table hold the quantities dates and the related information from the two tables.

email_table
e_id , email
1 , [e-mail]
2 , xcvxcv@asdélkasd.com

items_table
item_id , item_name
1 , plane  

then the orders will be:

orders_table
order_id , email_id, item_id , orderdate
1 , 1 , 1 , ____-__-__
2 , 1 , 1 , ____-__-__
3 , 2 , 1 , ____-__-__