Well maybe I sould map this out more clearly...
members
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| rowid | int(11)
Right list.
What you want is an outer join. Very simple example:
person
---
personID
===
name
region
===
attendance
---
attendanceID
===
date
personID FK into person
eventid FK into event
===
Select event.date,
person.name,
(attendance.personID is null) as present
from attendanc
You need a LEFT JOIN. Read about it here:
http://www.w3schools.com/sql/sql_join.asp
Go down to the "LEFT JOIN" section.
HTH,
Jed
I liked it when Chris Griffin wrote this to me:
> If this is not the right list for this please direct me to the proper
> list.
>
> I have a table of name/address
