aspose file tools*
The moose likes JDBC and the fly likes out putting a table but putting null in the rows where the attributes are not listed. (outer join) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "out putting a table but putting null in the rows where the attributes are not listed. (outer join)" Watch "out putting a table but putting null in the rows where the attributes are not listed. (outer join)" New topic
Author

out putting a table but putting null in the rows where the attributes are not listed. (outer join)

bhavin ragha
Greenhorn

Joined: Mar 28, 2012
Posts: 17
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

SELECT *
FROM bands
left join band_members
where band_members.band_id = bands.band_id
bhavin ragha
Greenhorn

Joined: Mar 28, 2012
Posts: 17
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
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

you are missing the word OUTER
this page looks quite good http://db.apache.org/derby/docs/10.2/ref/rrefsqlj18922.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: out putting a table but putting null in the rows where the attributes are not listed. (outer join)