Some tables mixed together
- by DJPython
Hello.
I have 2 different tables in my database. They have some variables common and some different. For example:
Table1:
ID
Date
Name
Address
Fax
Table2:
ID
Date
Name
e-mail
Telephone number
I want to display data together sorted by date & ID but from both tables. For example, first displayed will be the newest record from first table, but the second one will be the record from another table posted right after first one.
Hope everybody understand, sorry for my English.
Cheers.