Select Syntax => allg. Select

[Tobias Nix]

Hallo,

wie bekomme ich aus diesem Select:
SELECT b.id AS id, b.l AS l, b.r AS r , b.subject AS subject, b.parent AS
parent, b.author AS author, b.email AS email, b.email_replay AS
email_replay, b.timestamp AS timestamp, count(*) AS level FROM tree AS a,
tree AS b WHERE b.l BETWEEN a.l AND a.r AND b.r BETWEEN a.l AND a.r

diesen (sinn):
SELECT count(*) AS level,*  FROM tree AS a, tree AS b
WHERE b.l BETWEEN a.l AND a.r AND b.r BETWEEN a.l AND a.r
Irgendwas scheint hier nicht an der Syntax zu stimmen.

Hintergrund ist, das ich nicht genau weiss, welche felder ind der Tabelle
vorhanden sind,
ich aber trotzdem alle Daten auslesen möchte.

Kann mir jemand weiterhelfen ?
Tobias Nix.


---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql