Combine/append tabels in SQL

[MartinCarlsson]

Hi
I have a question about SQL.
I知 more of an Excel guy than an SQL guy, so bear with me

I知 writing this SQL question here since I値l use the result in Power Pivot.

I have tree tables Transactions2010, Transactions2011 and Transactions2012
They all have the same column definitions.

I need to combine the tree tables in one query, so I get all data from a query like:
SELECT * FROM (Transactions2010, Transactions2011 and Transactions2012)

Br
Martin

[Norie]

Martin

Use UNION.

<query1>
UNION ALL
<query2>
UNION ALL
<query3>

[MartinCarlsson]

Perfect !!

Thank you

Martin

Use UNION.

<query1>
UNION ALL
<query2>
UNION ALL
<query3>