# of columns in two selected tables or a query of a union query do not match

I have a simple qry that give me error

SELECT * 

FROM qry_ExecSum

inner join qry_IDS_IT_Everything on qry_ExecSum.P_Code = qry_IDS_IT_Everything.P_Code

It works good If change the * to column names like this :

SELECT qry_ExecSum.P_Code

FROM qry_ExecSum

inner join qry_IDS_IT_Everything on qry_ExecSum.P_Code = qry_IDS_IT_Everything.P_Code

All individual queries run good!!