help with sql query to return existing and non existent records

Question

i've tried a few example and can't seem to grasp how to do this. can someone help?

this query returns 1 row with the quantity for the item. there are 2 items not currently in inventory, so they're not in the table.

select styl from idcase where (whse = 'FP' and styl IN ('799941', '799950','799981'))

799941 200

how do i write the query so it shows

799941 200

799950 0

799981 0

Answer 1

sorry, no luck. just forget it. i don't want anybody to waste any more time on something that i think should be simple.