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)
Total Post:159
Points:1117MSSQL Server MSSQL Server
Ratings:
1189 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!