Evo jedan primercic. Tabele u primeru su Patient i Study, a ListaPolja su polja koja treba da budu selektovana. Napravis novi Query u Accessu i onda mu menjas u DesignViewu JOIN PROPERTIES. Imas tri slucaja, prvo ide opis, pa SQL upit
1) Only include rows where the joined fields from both tables are equal
SELECT ListaPolja
FROM Patient INNER JOIN Study ON Patient.PatientID = Study.PatientID
2) Include ALL records from 'Patient' and only those records from 'Study' where joined fields are equal
SELECT ListaPolja
FROM Patient LEFT JOIN Study ON Patient.PatientID = Study.PatientID
3) Inlude All records from 'Study' and only those records from 'Patient' where joined fields are equal
SELECT ListaPolja
FROM Patient RIGHT JOIN Study ON Patient.PatientID = Study.PatientID