bei Access muss man bei mehr als einem Join Klammern setzen: z.B. SELECT * FROM(CATEGORIES INNER JOIN TOPICS ON CATEGORIES.CA_ID = TOPICS.TO_CA_ID) INNER JOIN xxx ON xxx.x_ID = TOPICS.TO_CA_ID WHERE CA_ID = 1 Gru�, Andreas > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Stefan H�sler > Gesendet: Mittwoch, 12. M�rz 2003 16:06 > An: ASP Database > Betreff: [Database.asp] Inner Join > > > Hi! > > Wie m��te eigentlich mein SQL aussehen, wenn ich noch ne dritte > Tabelle per > INNER JOIN da reinbringen m�chte? > > SELECT * FROM CATEGORIES INNER JOIN TOPICS ON CATEGORIES.CA_ID = > TOPICS.TO_CA_ID WHERE CA_ID = 1 > > Danke > > Stefan > http://www.drhirn.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ > Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular > ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com > _______________________________________________ > Database.asp mailing list > [EMAIL PROTECTED] > http://www.glengamoi.com/mailman/listinfo/database.asp
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
