Re: Multi-table Join (WAS: Is there Examples and Documents on joining tables?)

2002-10-04 Thread Roger Baklund
* Michael T. Babcock > Its well appreciated to see examples of what works and what doesn't too; > its nice to know how to get one's queries in an order that makes the > MySQL optimizer's life easier. I'm trying to decide if there's some > logical way to inform MySQL that it can reorder a series o

Multi-table Join (WAS: Is there Examples and Documents on joining tables?)

2002-10-03 Thread Josh Trutwin
Here is the query that I had in a PhP script that joins a bunch of tables (I'll try to make this look readable). If you're curious, it's for a motorcross site (www.springcreekmx.com): SELECT standings.rank, race.race_date, class.class_name, racer.racer_name, cycle.cycle_desc, race_event.racer_