starting in sql "syntax error FROM clause"

[splreece]

Morning all,

I am venturing into sql but stumped at the first hurdle.

I have 2 tables with the same headers and I want to combine the two (i.e. may has 100 entries and tbl_ams_apr16 has 100 entries so I want a unionall to bring back 200 entries.


each select works on its own but as a union all and with both selects I get the syntax error...

any thoughts...?


SELECT Postcode FROM May
UNIONALL
SELECT Postcode FROM tbl_AMS_APR16;

 

[JHB]

It is UNION ALL, and not UNIONALL!