I have read that it is possible to join two tables using function UNION
(select aaaa from xxxx
select bbbb from yyyy; )
using SQL language but trying it with MySQL I always get an error, although in the MySQL documentation is written that UNION is supported in the version installed on my PC but there are no examples on how to do it :-(
Please tell me how to do it.