CODEWITHSUNDEEP
phpmysqlsubquery
Stev
Stev

Reputation: 1

SQL: Column is ambigious

I have the following SQL query, which has a subquery in it:

SELECT * FROM `statics` WHERE `mmsi`= 
(SELECT `mmsi` FROM `positions`,`active` 
WHERE `active.mmsi` = `positions.position_ID`);

But when I execute it, I get the following error:

1052 - Column 'mmsi' in field list is ambiguous

Please help me on adjusting my query.

Upvotes: 0

Views: 81

Answers (1)

ffflabs
ffflabs

Reputation: 17491

Without seeing your table structure, this is a wild guess:

SELECT * 
FROM `statics` 
WHERE `statics.mmsi` = (SELECT `active.mmsi` 
                        FROM `positions`,`active` 
                        WHERE `active.mmsi` = `positions.position_ID`);

but I don't get why are you doing this with a subquery. This one should yield the same results

SELECT statics.* 
FROM `statics`, `positions`
WHERE `statics.mmsi` = `positions.position_ID`;

Upvotes: 3

Related Questions