i have to use a left outer join to list the band_ids, band_names and their members details. right now i just put *.
below is the sql, and it works. but only displays the bands that have members in it.
i want it to show all the bands and if they dont have members then put null in the rows
explain a little abot the tables.
bands(band_id, band_name) represents a list of bands
band_members(band_id, name, dob, country, sex) represents the members of the
bands in relation bands
(there are 9 bands and only 7 of them have members in them)
ok now the condition also states the if no members listed in the relation then the rows should still be listed but with null values for the band members details.
how do I show the other rows where the band_id, in the bands table in not in the band_members table
left join band_members
where band_members.band_id = bands.band_id
Joined: Mar 28, 2012
ok i have just found out if i use on instead of where then all the data is listed. but how do i put null in the rows where there is no data