조인

SELECT dealer. *
FROM `dealer`
INNER JOIN `member_table` ON dealer.id = member_table.U_ID
WHERE TO_DAYS( NOW( ) ) - TO_DAYS( member_table.etime ) <0