SQL Query for select data from multiple tables

Question

I have multiple tables with same metadata (column names are same). I want to select Latest Records from these table, ordered by CreationDate (such column exist in all tables). Something like this

marc_s · Accepted Answer · 2012-05-29 07:50:04Z

2

Not sure of the correct syntax in MSSQL, but you should be able to:

SELECT ... FROM table1 UNION table2

(where table1 and table2 have identical columns)

Hope this helps...

edited May 29, 2012 at 7:50

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 29, 2012 at 7:35

Joe Bowman

5042 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

marc_s Over a year ago

Welcome to StackOverflow: if you post code, XML or data samples, please highlight those lines in the text editor and click on the "code samples" button ( { } ) on the editor toolbar to nicely format and syntax highlight it!

Maysam Over a year ago

It worked:

SELECT top(3) OwnerID,NewsTitle,NewsCreationDate FROM MoviesNews UNION  SELECT top(3) OwnerID,NewsTitle,NewsCreationDate FROM  TheaterNews ORDER BY 3 DESC

Darshana · Accepted Answer · 2012-05-29 07:55:59Z

1

SELECT newTable.MyData, newTable.CreationDate FROM
(SELECT MyData, CreationDate FROM Table1
UNION
SELECT MyData, CreationDate FROM Table2) AS newTable
ORDER BY newTable.CreationDate DESC

answered May 29, 2012 at 7:55

Darshana

2,5486 gold badges30 silver badges58 bronze badges

Comments

dipa · Accepted Answer · 2012-05-29 07:36:49Z

1

Why dont you use alias for the tables and select all the columns of both the tables and give the columns different names as per the table names. I think this can help you out.

Thanks, Dipa

answered May 29, 2012 at 7:36

dipa

2631 gold badge4 silver badges12 bronze badges

1 Comment

dipa Over a year ago

The query can be like SELECT t1.[x] As 'X1',t2.[x] as 'X2' FROM [table1] as t1 INNER JOIN [table2] as t2 On t1.[y] = t2.[y]

Collectives™ on Stack Overflow

SQL Query for select data from multiple tables

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related