Skip to content
Advertisement

Concatenate in SQL and then use in Left Join

I have the following SQL code:

But I am getting an Invalid column name error

Hopefully its something simple but I cannot seem to work it out? Thanks!

Advertisement

Answer

This is how you can do what you need:

And here is a small demo:

DEMO

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement