关于数据库查询时报“query block has incorrect number of result columns”

原SQL语句

select user_id id,
user_name xm,
login_id,

jgbm,
password,
'1' logintype,
'' zplj
from sc_users a
where a.login_id='admin' and a.password='1'
union
select id,
xm,
yx login_id,
password,
'2' logintype,
zplj
from ty_zcxx
where yx='admin' and password='8FAC419DC06AE7FCDA80424B0F7761C2'
order by logintype

错误原因：union后的语句中少了jgbm,字段

问题解决