mysql left join column reorganizing

Total Post:159


 1753  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 '' 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 =

Please help me!

  1. Re: mysql left join column reorganizing

    Hi Samuel!

    Try this way! 

    ON (voucher_info.maker_id = 

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


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.