Hello, list!
(filter-fodder: sql,query)
I've got a problem that's been bothering me for quite some time:
If I've got two tables, where I list people who's paid their
membership fee, year, etc., and another table with the names
tbl_membernames : name_id, firstname, lastname
tbl_paid:
Hi, you need a LEFT JOIN on your query.
See http://mysql.com/doc/J/O/JOIN.html
Try somthing like:
SELECT m.firstname, m.lastname
FROM tbl_membernames as m
LEFT JOIN tbl_paid as p ON (m.name_id=p.name_id and p.year=2000)
WHERE p.name_id IS NULL
On Mon, 2002-04-29 at 09:37, Markus Lervik
