The names and number of the columns in the outcomes desk replicate the name and range of columns queried by the main SELECT statement. Be aware that when applying UNION to query various columns from more than one desk, https://mazkingin.com/mysql-masterclass-master-basic-to-advanced-mysql-queries/