Jump to content

How do I join two tables in an SQL query?


ashburnham

Recommended Posts

I have two tables in my database as follows:

 

`table1`

refstartend

278XYZ123

279XYZ348

282XYZ982

 

`table2`

refstartend

280ABC439

281ABC398

 

As you can see they have exactly the same headers.  I would like to run an SQL query that integrates these two tables and orders it by the `ref` column so we have a result as follows:

 

refstartend

278XYZ123

279XYZ348

280ABC439

281ABC398

282XYZ982

 

Any help on this would be much appreciated, thanks...

 

P.S. The `ref` column is unique between the two tables so there would never be duplicate ref.

Link to comment
https://forums.phpfreaks.com/topic/93092-how-do-i-join-two-tables-in-an-sql-query/
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.