Mysql : get data from 2 tables (need help)
- by quangtruong1985
Assume that I have 2 tables : members and orders (Mysql)
Members :
id | name
1 | Lee
2 | brad
Orders :
id | member_id | status (1: paid, 2: unpaid) | total
1 | 1 | 1 | 1000000
2 | 1 | 1 | 1500000
3 | 1 | 2 …