A.
select supplierid , suppliername , supplieraddress from supplier where suppliername = ' 张明 '
B.
select * from supplier where suppliername = ' 张明 '
C.
select supplierid , suppliername , supplieraddress from shopxk where suppliername = ' 张明 '
D.
select supplierid , suppliername , city from supplier where suppliername = ' 张明 '