Help getting column data from another table

[thegaffney]

Hey,

Im new here, usually If I cant figure out how to do something I search endlessly over the internet untill I find how to do it, but a few things have me stumped, so I might need some help from you guys if you can 🙂

Well anyways, in this site iam making, there is a admin control panel to manage inventory, orders, members etc.

In the member page I want to list all the currently registered members from the "tb_member" table, including the: "member, first_name, last_name, country, state, and last_login" columns from that table, but I also want to get this persons last order date, which the "order_date" column is in the" tb_order" table and of coarse the tb_order table contains a "member" column

I tried using LEFT JOIN to get the order_date for the memeber, but if the member has more then one order then that member appears more than once on the list, I just want it to show the most recent order this member did, as in a LIMIT 0, 1 when searching through "tb_order" for each memeber kind of thing

thanks for your help 😃

[bogu]

Try using SUBQUERY or with LEFT JOIN use a GROUP BY member AND in ORDER BY add the order date column DESC (this should return the last order date)...