Jump to content

Multiple Tables


paultaylor01

Recommended Posts

Hi all.

 

I've got 2 tables:

 

Table A

Table B

 

Both tables contain different fields, together with a date field (which has the same name, call it datefield for arguments sake). The tables are not linked or joined in any way.

 

Is it possible to extract and list the contents of the 2 tables, combined, and sorted in datefield sequence?

 

Cheers

Paul

Link to comment
https://forums.phpfreaks.com/topic/92155-multiple-tables/
Share on other sites

Thanks Fenway.

 

However, let's assume the 2 tables vary widely in terms of number of fields, field-types etc (as they do in this example). Table A has about 20 fields, Table B has about 5. The only 'common' field is the date field which is what I want the output sorted by.

 

I'm reading between the lines that UNION isn't applicable in this case? Is there any other solution?

 

Cheers

Paul

Link to comment
https://forums.phpfreaks.com/topic/92155-multiple-tables/#findComment-472069
Share on other sites

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.