[RESOLVED] Help on Select statement

[Mark_Nordstrom]

SELECT Attendance.Event, Attendance.Date, Sum(IIf([Name]="tnaril",1,0)) AS Attended
FROM Attendance RIGHT JOIN [Event List] ON Attendance.Event=[Event List].Event
GROUP BY Attendance.Event, Attendance.Date;

I got this working in MS Access. Basically it compares the Event_List.event row, to the Attendance.event row. Filtered by Attendance.name. It puts a 1 if rows match and a 0 if they dont. It works great in MS Access just when I transfered the tables to MYSQL I cant get it to work in PHPMyadmin.

[NogDog]

No guarantees, but this should be closer:

SELECT Attendance.Event, Attendance.Date, Sum(IF(`Name`='tnaril',1,0)) AS Attended
FROM Attendance RIGHT JOIN `Event List` ON Attendance.Event=`Event List`.Event
GROUP BY Attendance.Event, Attendance.Date;

[Mark_Nordstrom]

Thanks got it to run the quey. Now i just need to figure out why its not marking the event rows that match with a 1 🙂

[Mark_Nordstrom]

SELECT member_list.name AS mem, Sum(
IF (
member_list.name NOT LIKE 30dayatt.name, 1, 0
) ) AS status
FROM member_list
RIGHT JOIN 30dayatt ON 30dayatt.name NOT LIKE member_list.name
WHERE active='1'
GROUP BY member_list.name

This does whati want sorta. It shows all members and any member that doesnt match it shows 121 as status and im confused why 🙂