how to JOIN three tables in MS ACCESS 2007. the tables are:
*student (Primary key: StudentNumber)
*event (Primary key: Event_num)
*Transaction (Primary key: Transaction_num)

the MS ACCESS gives me this code, but nothing appears in the Datasheet view.

SELECT Student.StudentNumber, Student.Lastname, Student.Firstname, Student.Initial, Event.Event, Event.EventDate, Event.EventFee, Transaction.Status
FROM Student INNER JOIN (Event INNER JOIN [Transaction] ON Event.Event_num=Transaction.Event_num) ON (Student.StudentNumber=Transaction.Student_num) AND (Student.StudentNumber=Event.Student_num);
Re: how to join three tables in MS ACCESS 2007 80 80


SELECT Student.StudentNum, Student.FirstName, Student.LastName, Student.Initial, Event.Event, Event.EventDate, Transaction.Status
FROM (Student INNER JOIN Event ON Student.StudentNum = Event.StudentNum) INNER JOIN [Transaction] ON Student.StudentNum = Transaction.StudentNum;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.