mysql select two tables problem

[rbrallos]

---

SELECT user.user_id, user.email, notifications.status
FROM user
LEFT OUTER JOIN notifications ON users.user_id = notifications.user_id
WHERE notifications.status = 1

[Tin_Tin]

Pili-a jud ang pinaka pas2x inig retrieve nimo sa data.

[towerblo_xx]

it helps for me thanks ani..