forum

home / developersection / forums / mysql left join column reorganizing

mysql left join column reorganizing

Samuel Fernandes 2437 12-Feb-2013

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!


Updated on 13-Feb-2013
Can you answer this question?

Answer

1 Answers

Liked By