LEFT JOIN i WHERE Opcje

[spyro]

Kod:

Kod

$sql = "SELECT u.user_id
               FROM " . USERS_TABLE . " u
               WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
               ORDER BY $order_by";

Natomiast jeżeli dodam:

Kod

$sql = "SELECT u.user_id, ud.user_id, d.pf_is_partner as is_partner, d.pf_is_partner_ver as is_partner_veryfied
               FROM " . USERS_TABLE . " u,
               ". PROFILE_FIELDS_DATA_TABLE ." d
               LEFT JOIN ". PROFILE_FIELDS_DATA_TABLE ." ud
                   ON (d.user_id = ud.user_id)
               WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
               ORDER BY $order_by";

Źle bierze pod uwagę ORDER BY... Co robię źle?
PS. Wersja MySQL: 4.0.16

Ten post edytował spyro 15.10.2008, 12:01:27

[spyro]

Sporo poprzerabiałem i wygląda to tak:

Kod

                $sql = 'SELECT u.*, d.pf_is_partner as is_partner, d.pf_is_partner_ver as is_partner_veryfied
                    FROM ' . USERS_TABLE . ' u
                    LEFT JOIN '.PROFILE_FIELDS_DATA_TABLE.' d
                    ON (u.user_id = d.user_id)';

I wyskakuje mi błąd: Column: 'user_id' in where clause is ambiguous [1052]
(IMG:http://forum.php.pl/style_emoticons/default/blinksmiley.gif) (IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif) ?