w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
My CASE statement is wrong. Any idea what I am doing wrong?

You have an extra ) at the end of your case statement remove that.

 0 then 'full' else STR(Seating_Capacity) end)
                                            ^^^

for Seating_Capacity try accessing it with table alias like l.Seating_Capacity





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.