Groups | Search | Server Info | Login | Register

Groups > comp.databases > #90

Re: joining tables and the order changes

Show all headers | View raw

[This followup was posted to comp.databases and a copy was sent to the 
cited author.]

In article <ituuo7$7cd$1@speranza.aioe.org>, art.ward@noreply.xx says...

...

> > How can i display the records in the dealsbasket in the order they
> > were imported into the table and then display prod description as well
> > with out that order changing.
> >
> > Im using sql server 2000
> 
> In the hope that this was a homework question, I'll just point out that
> SQL databases don't have "records" they have rows, and rows are just

True, but rather picky.  Most working database people use the terms 
"rows" and "records" relatively interchangeably.  Everybody understands 
what you mean either way.  The rest of your (snipped) post is qute a 
good explanation, though rather abstract in its wording.

For the OP:  if you want your records back in a specific order, you MUST 
tell it what that order is.  If you want it in the order they were 
inserted, then there has to be a field that helps the db engine figure 
out what that order was.  Typical ways of achieving this are timestamps 
and automatically incrementing integer keys.

Back to comp.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

joining tables and the order changes shawrie <tourerukcom@googlemail.com> - 2011-06-22 07:44 -0700
  Re: joining tables and the order changes Ben Finney <bignose+hates-spam@benfinney.id.au> - 2011-06-23 07:47 +1000
  Re: joining tables and the order changes Arthur Ward <art.ward@noreply.xx> - 2011-06-23 08:50 +0000
    Re: joining tables and the order changes David Kerber <dkerber@WarrenRogersAssociates.invalid> - 2011-06-23 09:09 -0400
      Re: joining tables and the order changes Arthur Ward <art.ward@noreply.xx> - 2011-06-23 13:23 +0000
        Re: joining tables and the order changes David Kerber <dkerber@WarrenRogersAssociates.invalid> - 2011-06-23 14:35 -0400
    Re: joining tables and the order changes toledobythesea@yahoo.ca - 2011-06-24 10:40 -0700
      Re: joining tables and the order changes Arthur Ward <art.ward@noreply.xx> - 2011-06-25 12:33 +0000
        Re: joining tables and the order changes paul c <toledobythesea@yahoo.ca> - 2011-06-25 14:44 -0700
        Re: joining tables and the order changes paul c <toledobythesea@yahoo.ca> - 2011-06-25 14:53 -0700
          Re: joining tables and the order changes Lee Fesperman <firstsql@gmail.com> - 2011-07-04 00:39 -0700

csiph-web