Hi, I have some problems in select statement.
Let's say I have a table called MYJOURNEY which have TripNum, TripCount, Departure, Destination. E.g.
(3,1,'America', 'New Zealand')
(3,2,'New Zealand', 'Indonesia')
I need to select TripNum, TripCount, Departure, RestPt, Destination where RestPt refer to New Zealand.

Sorry I forgot to tell u that the countries may not be New Zealand. This is only part of the table.

And where exactly does RestPt come into the equation??

Originally Posted by Redbull

Hi, I have some problems in select statement.
Let's say I have a table called MYJOURNEY which have TripNum, TripCount, Departure, Destination. E.g.
(3,1,'America', 'New Zealand')
(3,2,'New Zealand', 'Indonesia')
I need to select TripNum, TripCount, Departure, RestPt, Destination where RestPt refer to New Zealand.

http://www.comptechdoc.org/independe...sqlselect.html

But what is RestPt???