Query

What will happen if following query get executed:

select CategoryID, Quantity, Price

from Customer c, SalesOrderDetail sod

where sod.clientid in (select customerid where pricingplan='X')

In this Query options nothing was spoken about pricingplan column.

If pricingplan column is not part of either of the tables then the query will end up in Error. Why not the Third option is right answer for this Question in this scenario?? 🙂