[bhavin5]

ok so i have an SQL query. but i want to put null where there is no data how do i do this.

[modi123_1]

First your column needs allow nulls.

Then you just do something like:

update <table name>
set
<column name> = null
where <condition>

What does your query look like?

[bhavin5]

SELECT *
FROM bands
left join band_members
on band_members.band_id = bands.band_id

what is my table name. as it's a query.

[modi123_1]

Oh.. you are doing a join? Well that's a bit different. Left join should provide nulls where there is data in the left table and not in the right.

Where do you exactly want the nulls to be?

[bhavin5]

i want the nulls to be where there is no data... right now they are just blank.

my assignment question is: Use a left outer join to list all band_ids, band_names and their members details. If they have no members listed in the band_members relation then the band_id and band_name
should still be listed but with null values for the band members details.

"null values" does that mean if there is no data then "null" should be displayed.
or does it mean blank space.

[modi123_1]

What database are you using? MSSQL should provide nulls in the cells that don't have matching data.

[bhavin5]

i am using SQLite database browser

[modi123_1]

That makes some sense. SQLlite tends to show, what everyone else would call a null, as a blank space.

[bhavin5]

lol so i have answered the questions... thanks guys!!!