Categories
Database Development

How to exclude data if another column is null?

This SQL query returns a column called "organisation_names" however the data is coming from a column called organisation_users and I would like to exclude "organisation_names" if… organisation_users.delete_at === null otherwise return the column Considering the SQL query below, got any ideas? I was considering adding column: GROUP_CONCAT(CONCAT(organisation_users.deleted_at)) as organisation_users_deleted_at Then excluding it on the query […]