Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Please Help With SQL

Please Help With SQL

From: Alison Pont <aPont8892_at_hotmail.com>
Date: Tue, 12 Mar 2002 17:57:01 -0500
Message-ID: <a6m064$1pl$1@slb0.atl.mindspring.net> 





Table Bands with columns:


BandId, BandName



Table Albums with columns:


AId, BandId, Title, YearProduced



How do find all bands that recorded TWO albums in the same year? I want to
output BandName and the names of each of two albums (the Tiltles) in the
same record.



eg.

BandName    Title                 Title             YearProduced
----------------------------------------------------------
Bread             BestHits1         BestHits2     1982
James Last      Classic1           Classics2      1988





Thanks in advance.
Received on Tue Mar 12 2002 - 16:57:01 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US