&MySQL "INNER JOIN"-Fragen

[Daniel]

Hi,

SELECT a.id AS aid, b.id AS bid FROM table AS a, table AS b WHERE ...

Vielen dank, das funktioniert zum glück auch bei

SELECT a, ab, af, asdf, ... momo.a AS alfe, momo.b AS belfe FROM tabelle
INNER JOIN tabelle2 AS momo
ON(tabelle=id_a = tabelle2.id_a)
INNER JOIN tabelle2 AS momo
ON(tabelle=id_b = tabelle2.id_b)

MfG