Re: [GENERAL] ordering rows

2007-10-18 Thread Bob Pawley
That's marvelous - thanks. Bob - Original Message - From: "brian" <[EMAIL PROTECTED]> To: Sent: Thursday, October 18, 2007 9:45 AM Subject: Re: [GENERAL] ordering rows Bob Pawley wrote: Hi I have a table 'import' which is an amalgam of two other tab

Re: [GENERAL] ordering rows

2007-10-18 Thread brian
Bob Pawley wrote: Hi I have a table 'import' which is an amalgam of two other tables 'loops' and 'devices'. The ID column of loops is reflected in the import table. However the order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1. These are the IDs from loops? I need to fetch the

[GENERAL] ordering rows

2007-10-18 Thread Bob Pawley
Hi I have a table 'import' which is an amalgam of two other tables 'loops' and 'devices'. The ID column of loops is reflected in the import table. However the order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1. I need to fetch these rows one at a time, in sequence with the loop ID