alexa

Is there way to return null valued rows when when querying joined table in SQL ?

Is there way to return null valued rows when when querying joined table in SQL ?

Try to use a nested SELECT, this should return null for the users without any event:

 select 
    u.name, 
    SELECT(
      group_concat(content)  
        FROM 
      events 
        WHERE 
      userId = u.id
    ) as events 
from 
    users u
order by 
    u.id

1352 0
7

Write a Comments


* Be the first to Make Comment

GoodFirms Badge
GoodFirms Badge

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online

Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
Quick Inquiry