---
title: "mysql left join column reorganizing"  
description: "mysql left join column reorganizing"  
author: "Samuel Fernandes"  
published: 2013-02-12  
updated: 2013-02-13  
canonical: https://www.mindstick.com/forum/592/mysql-left-join-column-reorganizing  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# mysql left join column reorganizing

Hi Everyone!

I have a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) [named](https://answers.mindstick.com/qa/44918/what-is-a-no-day-yet-named-motion) application_user which have a [field](https://www.mindstick.com/forum/160867/does-mindstick-provide-training-for-field-marketing) 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](https://www.mindstick.com/blog/114552/how-to-fix-mozilla-firefox-error-code-2324): 1054\
Unknown [column](https://www.mindstick.com/forum/33860/how-to-calculate-column-summary-in-sql-server) 'application_user.id' in 'on [clause](https://www.mindstick.com/forum/33937/difference-between-throw-exception-and-throw-clause)'\
Can [anyone](https://www.mindstick.com/articles/23207/how-to-find-the-best-fit-job-for-anyone) please help me on this please ? Here is my code below :

[LEFT JOIN](https://www.mindstick.com/blog/304465/difference-between-inner-join-left-join-right-join-and-full-outer-join-in-sql-server) application_user AS maker\
ON(voucher_info.maker_id = application_user.id)

Please help me!\
Thanks!

## Replies

### Reply by AVADHESH PATEL

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.


---

Original Source: https://www.mindstick.com/forum/592/mysql-left-join-column-reorganizing

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.