SQL version of VLOOKUP
It looks as if you need an outer join, I’ll use a left one in my example: You can also leave out the outer keyword:
join
“Not unique table/alias” in MySQL
You are joining the same table 2 times and hence you need to provide the unique alias name. However looks like you are looking for parts table and hence need to join that table For better readability you can always give some short alias name something as