CODEWITHSUNDEEP
mysqlleft-join
Lou
Lou

Reputation: 4474

LEFT JOIN not working with an empty table

I have a problem getting results from the following query:

SELECT SQL_CALC_FOUND_ROWS App.ID, UserFeedback.Type FROM App 
LEFT JOIN UserFeedback ON App.ID = UserFeedback.App_ID

It's not returning anything, and I am suspecting that it has to do with UserFeedback being empty. There is a single row in the Appointments table, and it's returned when I use SELECT * FROM Appointments.

Am I doing something wrong?

Upvotes: 0

Views: 144

Answers (1)

bytepirate
bytepirate

Reputation: 329

the query is fine with an empty join-table, something else must be wrong

Upvotes: 1

Related Questions