Wednesday, July 13, 2011

Hi. I am a beginner in SQL...I have a doubt on the following query...?

The column name 'price' must exist in at least two of your tables pc, laptop and printer and the query doesn't know which one you want. Qualify price in your SELECT column list just as you did with model to specify which one you want included. However, I question why you have the other tables included when there is no JOIN or WHERE criteria to relate the three of them together. That also goes for the subquery...why do it that way when it appears you can simply join model to product?

No comments:

Post a Comment