This topic is locked

many to many links to a many to many

2/10/2012 3:04:01 AM
PHPRunner General questions
M
mune72 author

I explain better with an example.
There is table CLASSES (in a college) which has a many-to-many link with the table STUDENTS which, in turn, has a many-to-many relation with the table SCHOOLS (the high school they graduated).
The DB actually has five tables

CLASSES

STUDENTS

SCHOOLS

CLASSES_STUDENTS

STUDENTS_SCHOOLS
When I show the contents for the table CLASSES_STUDENTS I can access fields of the table CLASSES and the STUDENTS, but if I want, for example, print the field ADDRESS of the table SCHOOLS how can I do that?
Thanks

J
Jane 2/10/2012

Hi,
you can join CLASSES_STUDENTS, CLASSES and SCHOOLS tables on the Edit SQL query tab. Then add ADDRESS to the pages on the Choose fields tab.