SELECT * FROM CATEGORIES 
INNER JOIN TOPICS ON CATEGORIES.CA_ID =TOPICS.TO_CA_ID 

inner join ... on ...
inner join ... on ..
left outer join ...

WHERE CA_ID = 1

Beliebig viele..

Matthias D.
~~~~~~~~~~~~~~~~~~~~~~~~~~~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

Antwort per Email an