I have 2 tables Site_2002 and Site_2003. These represent the same data from different years. Instead of continuing to create new tables each year, I would like to merge these tables into a single table.

What I’m looking to do is create a new table with a Fiscal Year column. Add the contents of Site_2002 and Site_2003 to the new table and at the same time set the values of the FY column to match whichever table the data is coming from.

Could someone give me an idea on how to start this? I’m not very good with SQL and I’m not sure which functions are needed to pull this off. I hope with a nudge in the right direction I can figure this out. Any pseudo code would be greatly appreciated.