New to MySQL

2002-08-24 Thread Jeremy Proffitt
Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to

Re: SQL JOIN Challenge - Help Please

2002-08-24 Thread Brian Moon
If I read right, this is a pretty basic join so I am assuming that you have never done a join in your life. select distinct order.order_id from order inner join transaction_log on order.order_id=transaction_log.order_id and transaction_log.event_log_id <> 3 Brian. -