SQL union question?

SELECT ......

where u.id in (

(select `entityId` as userid from table_a


select userid from table_b) g

This gives me an error! Column ‘userid’ in field list is ambiguous

I can’t seem to understand which column to use when employing union!

Will the bottom table get merged into the top one and I need to use the top table’s column as reference?

If I use SELECT * gives me an error about the fact that there can only be one column!

Please take a look at my query.

P.S. Should I use SELECT userid or SELECT entityId


SELECT ......
From ....
where u.id in (
    select `entityId`  from table_a
    select userid from table_b


if you could please show your entire query, i’m sure it can be simplified to remove the subquery

Thanks brother! So it doesn’t matter whether I use SELECT userid or SELECT entityId ??

thanks brother for trying to help but the query is super complex and for security reasons I can’t post the structure.

of course it does, but without a better example, i’d only be guessing

Every single time I have seen UNION on the help forums it was always a bad/improper DB design behind it. If that is the case, that is what needs to be addressed. Without seeing what you have we cant really help you.

You can always PM me your DB schema and I will review it.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.