Hi,

Any experts who can answer this? (prob quite a simple question!)

I have a Members table and an Attendance table and have some questions: If I want a one to many relationship since one member can have many attendances, do I need a joining table?

twice as long as it is from one end to the middle.



OR

It all depends on how you structure the tables.

Yes, you'd need a way to join the tables. You can do it either with a joining table created specifically for that pupose or you add member id in each attendance table record itself.

yes you need to join the table or you can use this query

select * from attendance where attendance.memberid in (select memberid from members where...)