SQL Error : Ambiguous column name 'last_name'.

[jasonj]

Oh the pain .. the pain .... EMAIL GROUP INBOX module.. sort by Contact and then try and move through the record set... BANG you get SQL Error : Ambiguous column name 'last_name'. Is there a dummies guide to how SUGAR generates its SQL query strings.. I think know what is wrong .. I just don't know where to "tinker" with the syntax.

[hkphooey]

I've encountered this writing queries for MySQL by hand. Seems to be something to do with backquotes. eg

SELECT * FROM table1 LEFT JOIN table2 on table1.last_name=table2.last_name

will work, whereas

SELECT * FROM table1 LEFT JOIN table2 on `table1.last_name`=`table2.last_name`

will not, giving the error you state. Can't figure out why this would be so. Running MySQL 5.x

[egork]

I've encountered this writing queries for MySQL by hand. Seems to be something to do with backquotes. eg

SELECT * FROM table1 LEFT JOIN table2 on table1.last_name=table2.last_name

will work, whereas

SELECT * FROM table1 LEFT JOIN table2 on `table1.last_name`=`table2.last_name`

will not, giving the error you state. Can't figure out why this would be so. Running MySQL 5.x

Hi, just a wild guess, may be putting something in quotes makes it to be one token, so it won't get parsed into table name and column name, giving you an error? (object not found, right?)