Re: ORDERING A LEFT JOINED TABLE

2001-11-17 Thread Anvar Hussain K.M.
Hi, At 05:35 PM 15/11/2001 -0800, you wrote: I'm having a problem sorting records that are used in a left join statement. Basically what happens is that any record that is not in table1 doesn't get sorted correctly. It first sorts all the records that have valid 'c2' records in both table1 and

ORDERING A LEFT JOINED TABLE

2001-11-15 Thread Brett Lytle
I'm having a problem sorting records that are used in a left join statement. Basically what happens is that any record that is not in table1 doesn't get sorted correctly. It first sorts all the records that have valid 'c2' records in both table1 and table2, then moves on to all the records that