Hi,
try this
SELECT user.*, wbs.name
FROM
user_wbs INNER JOIN user ON user.id = user_wbs.user_id INNER JOIN
wbs ON wbs.id = user_wbs.wbs_id
that should do the same as your select
just MySQL doesnt like nested joins/selects
hope this will be sorted out in 4.1
Tommy
-----Original Message-----
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Mon, 25 Mar 2002 15:47
To: '[EMAIL PROTECTED]'
Subject: syntax question
Does anyone know what is wrong with my syntax? (the sql statement works in
mssql server)?
SELECT user.*, wbs.name
FROM wbs INNER JOIN (user INNER JOIN user_wbs ON user.id =
user_wbs.user_id) ON wbs.id = user_wbs.wbs_id
Thanks,
Scott
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
