mysql - I need to retrieve individual column from 3 different tables -

my sql server database has 3 tables (amount, wthdrwl, spent), each table has got id, , amount column. want retrieve amount column these 3 different tables.

for both mysql, sql-server, use union (implicit distinct) or union all:

select amount amount union select amount wthdrwl union select amount spent