> Hello, > I've been trying to figure this out but I feel like I'm just > banging my head > on the wall.
That must be quite painful... > I hope this is the right forum to pose this question. It's certainly one of the better ones, yes. > I have a table of flights which has several fields > > >Table: flights > >Fields: depart, depart_time, arrive, arrive_time, flight_no, flight_group > > I'm trying to do a search on "depart" and "arrive" and show only > the records > which have matching "flight_group" You're not providing a lot of information. Is it something like this, you're looking for: SELECT t1.depart_time, t2.arrive_time FROM flights AS t1, flights AS t2 WHERE t1.flight_group = t2.flight_group; / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php