Need help with a Union Query

[jdowdy]

Trying to Union to tables together but can't get it to work.
I want to combine both tables into 1 single table and keep everything in both:

SELECT
a.OtherPropertyCode,
a.GrossTrans_TY,
a.GrossTrans_LY
from (
select


Table2_PropertyTrx_TY.OtherPropertyCode,
Table2_PropertyTrx_TY.GrossTrans_TY,
from Table2_PropertyTrx_TY
UNION ALL
select
Table3_PropertyTrx_LY.OtherPropertyCode,
Table3_PropertyTrx_LY.GrossTrans_LY
from Table3_PropertyTrx_LY
) a

[RuralGuy]

I would start with two separate queries that work and then put them together.