Re: SQL Oracle Row Query ?
From: <uwe.mahlmann_at_dusnet.de>
Date: Mon, 13 Nov 2000 18:54:11 GMT
Message-ID: <20001113.18541159_at_mis.configured.host>
Date: Mon, 13 Nov 2000 18:54:11 GMT
Message-ID: <20001113.18541159_at_mis.configured.host>
Select one.recordName
From Records one, Records two
Where one.recordName = two.recordName
And one.releaseYear != two.releaseYear
/
I hope this helps you
Uwe
> I have a table name records with attributes recordName and releaseYear
.
> No recordName was ever repeated from year to year, but some records
> came back after a gap of one year. Find those titles.
> Hope someone can help,
> Yours, Steven
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 13 2000 - 19:54:11 CET