Utenti
Un gabbiano a scuola
- OpenOffice.org:
- per insegnanti
- per studenti?
- per genitori?
- per amministratori
Ambiti disciplinari
Cerca argomento
Sezioni
Web tools
Aiuto
SELECT students.name AS Nome, students.surname AS Cognome, students.address AS Indirizzo, students.town AS Comune, students.mobile AS Cellulare, areas.name AS Area, courses.title AS Corso, subscriptions.edition AS Edizione, calendar.start_date AS "Data d'inizio" FROM (students INNER JOIN ((courses INNER JOIN calendar ON courses.id = calendar.course) INNER JOIN subscriptions ON calendar.id = subscriptions.edition) ON students.id = subscriptions.student) INNER JOIN areas ON courses.area = areas.id
WHERE (((calendar.start_date)>Now()))
-- MarcoCaresia - 26 Jan 2007