java面試題,關於數據庫的建表和查詢

USER表

ID,USER_NAME,GENDER,HOBBY,EDUCATION

MERCHANT表

ID,NAME,SHOP,SEQ_NUM,PERSON,TEL

LOGIN表

ID,NAME,PASSWORD,MOBILE

登陸表的id於會員表和商戶表的id關聯。

2.

select L.ID,L.NAME,L.PASSWORD,L.MOBILE from LOGIN L inner join USER U on U.ID=L.ID where U.NAME="王五"

3.

select M.*,L.NAME as LOGIN_NAME,L.PASSWORD,L.MOBILE from MERCHANT M inner join LOGIN L on L.ID=M.ID