【单选题】In the relation of tblMember (Member_Id, Title, Surname, Fname, Street_Address, Suburb, City, Phone, Email) ,Which SQL Command can find the member(s) with a surname like STRAIGHT or STRINGER, show Me...
A.
select Member_Id,Surname,FName,Street_Address,City from tblMember where Surname like ( 'STRAIGHT' , 'STRINGER' ) order by Member_Id;
B.
select Member_Id,Surname,FName,Street_Address,City from tblMember where Surname = ( 'STRAIGHT' , 'STRINGER' ) order by Member_Id;
C.
select Member_Id,Surname,FName,Street_Address,City from tblMember where Surname = 'STRAIGHT' and Surname = 'STRINGER' order by Member_Id;
D.
select Member_Id,Surname,FName,Street_Address,City from tblMember where Surname in ( 'STRAIGHT' , 'STRINGER' ) order by Member_Id;