SQL 연습

SQL JOIN문 테이블3개

SELECT TB1.mid, TB1.seller, TB1.connect, TB1.grade, TB1.rcmd_mid, TB1.name, TB1.phone, TB1, telecom,
TB1.date_type, TB1.join_date, TB1.last_login, TB1.cash, TB2.model_num, TB1.member_date, TB3.model_name
FROM tb_member_list TB1 JOIN tb_member_device_list TB2 on TB1.mid = TB2.mid
JOIN tb_device_list TB3 on TB2.model_num = TB3.model_num
WHERE TB1.grade='D' order by TB1.join_date DESC LIMIT 0, 20;