Re: Joins~

On Wed, 2001-11-21 at 09:37, Gurudutt wrote:
> I want to sort the combination of the result set, like
> suppose an entry exists in tickettab as 2001-11-12 12:30
> and the next entry in tickettab is 2001-11-12 16:40
> 
> if there exists a entry in ticketmultab as 2001-11-12 13.30
> then I should get  the results as follows
> 
> 
> ticketid      arrival date    arrival time
> 
> 1             2001-11-12      12:30:00              -- tickettab entry
> 2             2001-11-12      13:30:00              --ticketmultab entry
> 3             2001-11-12      16:40:00              -- tickettab entry

maybe it works like this:

select * from (<join tickettab and ticketmultab however you want to) as
ticketjoined order by ticketjoined.arrivaldate, ticketjoined.arrivaltime

let me know if it works.

Markus Bertheau