CODEWITHSUNDEEP
mysqlleft-joinnavicattable-relationships
George McKinnon
George McKinnon

Reputation: 11

Navicat MySQL Query Column is null when joining two tables(customer and order table relationship)

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...

Upvotes: 1

Views: 552

Answers (1)

Tse Kit Yam
Tse Kit Yam

Reputation: 303

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.

Upvotes: 0

Related Questions