Re: ORDER BY problem with JOINs

2004-09-10 Thread Paul DuBois
At 17:00 -0600 9/10/04, René Fournier wrote: I've got a SELECT statement that is returning the data I want, but not in the right order (and I don't know why...). Let's say there are two tables, People and History. Some records in People have corresponding records in History, but not all--so I

Re: ORDER BY problem with JOINs

2004-09-10 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 10 September 2004 18:00, René Fournier wrote: > I've got a SELECT statement that is returning the data I want, but not > in the right order (and I don't know why...). Let's say there are two > tables, People and History. Some records in Peopl

ORDER BY problem with JOINs

2004-09-10 Thread René Fournier
I've got a SELECT statement that is returning the data I want, but not in the right order (and I don't know why...). Let's say there are two tables, People and History. Some records in People have corresponding records in History, but not all--so I need a LEFT JOIN TO connect history.people_id