Wednesday, February 24, 2010

Sold Books

Have been sold: 55
select partnum, bktitle from titles
where partnum in ( select partnum from sales)
Haven’t been sold: 37
select partnum, bktitle from titles
where partnum not in ( select partnum from sales)

No comments:

Post a Comment