Re: Simple SQL Query

vpg0002_at_hotmail.com (Vishwa Gaddamanugu) wrote:

>I am performing the following query and running into problems:
>
>Table:
>ID New Name PrevID
>===== ============== ======
>1 Old A
>2 Old B
>3 Old C
>4 Old D
>5 Old E
>6 New A 1
>7 New B 2
>8 New C 3
>9 New D 4
>10 New E 5
>
>Query:
>SELECT movies.ID, movies.new_name "New Name", mov.new_name "Prev Name"
> FROM movies, movies mov
> WHERE movies.ID = mov.ID
> AND movies.PrevID Is Not Null;

Try

SELECT n.ID, n.new_name "New Name", o.new_name "Prev Name"   FROM movies o, movies n
 WHERE o.ID = n.PrevID

Hth,
Joachim

-- 
Diese Nachricht hat einen gueltigen From-Header. 
Emails an user_at_netcologne.de mit user = nc-zobeljo
werden sogar gelesen.