Displaying 1 result from an estimated 1 matches for "keywords_t1".
2006 Jan 22
2
suggest for "ambiguous column" when JOIN associated tables
...LECT keywords.id AS t1_r0, keywords.id AS t0_r0, keywords.group_id AS
t1_r2, keywords.group_id AS t0_r2, FROM keywords LEFT OUTER JOIN
keywords ON keywords.id = keywords.group_id;
My point is to use AS statement to refer JOIN''ed tables as aliases, so
we can produce query like:
SELECT keywords_t1.id AS t1_r0, keywords.id AS t0_r0,
keywords_t1.group_id AS t1_r2, keywords.group_id AS t0_r2 FROM keywords
LEFT OUTER JOIN keywords AS keywords_t1 ON keywords_t1.id =
keywords.group_id;
And all will be okay.
Unfortunately, I can''t propose this idea as a patch, due my lack of
experien...