get empty result from sql query

Question

I have this query:

select p1.cost as V1, p2.cost as V2 , p3.cost as V3 
from product p1, product p2, product p3 
where p1.id =1 and p2.id =2 and p3.id=3

In my product table I have just one row:

id   | name       | cost
1    | product1   | 20

As you can see here, I ll get empty result ! But how can I do to get:

V1   | V2  | V3
20   |     |

Mureinik · Accepted Answer · 2015-01-07 17:21:39Z

1

You could use left joins:

SELECT    p1.cost AS V1, p2.cost AS V2 , p3.cost AS V3 
FROM      product p1
LEFT JOIN product p2 on p2.id = 2
LEFT JOIN product p3 on p3.id = 3
WHERE     p1.id = 1

edited Jan 7, 2015 at 17:21

answered Jan 7, 2015 at 17:02

Mureinik

316k54 gold badges400 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrey Morozov Over a year ago

and maybe WHERE p1.id = 1?

Collectives™ on Stack Overflow

get empty result from sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related