1

Query

as you can see in the image the custom created column "customer" is null, but when I use the RIGHT JOIN is shows up, but then the idOrder is nulled...

Dharman
  • 30,962
  • 25
  • 85
  • 135
George McKinnon
  • 11
  • 1

1 Answers1

0

Check if there is any null values in your customer table, if there is any null values in the strings, the result of concat will be null too.

Tse Kit Yam
  • 173
  • 8