you want to see order number, product number and quantity of any item in
which the product number and quantity match both the product number and
quantity of an item in order 605
which select statement you want to use
select ordid , prodid , qty from item
where ( prodid , qty) in
( select prodid , qty from item
where ordid = 605 )
and ordid 605;
b. select ordid , prodid , qty from item
where prodid , qty in
( select prodidfrom item
where ordid = 605 )
and ordid !=605;
c.
select ordid , prodid , qty from item
where ( prodid,qty)
( select prodid , qty from item
where ordid = 605 )
and ordid not in ( 605 );
d. select ordid , prodid , qty from item
where ( prodid , qty) =
( select prodid , qty from item
where ordid = 605 )
and ordid 605;
谁能 告诉我A D的不同吗?
|