Jump to content

Selecting from two tables, displaying both results.


Jabop

Recommended Posts

I have two tables:

 

Table A

ID | Name | Date | Type

 

Table B

ID | Name | Date | Type

 

Each of these tables have identical table structure. What I am trying to achieve is selecting 10 records TOTAL, from BOTH of the tables, ordering by Date DESC.

 

What is the best method to go about this?

Zanag, that worked. Thank you! I need to do some research on UNION, because it is new to me.

 

Sure.. but that doesn't limit to 10.

 

Do you care where the 10 are from?

 

No, any result can be from either table - I just want the most recent 10 to display.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.