Home > DeveloperSection > Forums > mysql left join column reorganizing
Samuel Fernandes
Samuel Fernandes

Total Post:154

Points:1082
Posted on    February-12-2013 3:03 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 972  View(s)
Rate this:

Hi Everyone!

I have a table named application_user which have a field named id. Another table named voucher_info which has a field named maker_id. Now I want to LEFT

JOIN the application_user table with voucher_info table using maker_id with id ? But this error is shown instead:

Error Code: 1054
            Unknown column 'application_user.id' in 'on clause'
Can anyone please help me on this please ? Here is my code below :

LEFT JOIN application_user AS maker
    ON(voucher_info.maker_id = application_user.id)

Please help me!
Thanks!



AVADHESH PATEL

Total Post:604

Points:4228
Posted on    February-13-2013 12:40 AM

Hi Samuel!

Try this way! 

ON (voucher_info.maker_id = maker.id) 

Once you alias a table, you can only reference it by the alias.

Don't want to miss updates? Please click the below button!

Follow MindStick