Groups | Search | Server Info | Login | Register

Groups > comp.databases > #91

Re: joining tables and the order changes

Show all headers | View raw

David Kerber wrote:

> [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
>
>  Most working database people use the terms 
> "rows" and "records" relatively interchangeably.  

True, and as long as they know the difference they can get along fine. 
But rows aren't records; think of column stores for example. 

> Everybody understands 
> what you mean either way.  

Most people who already know the difference get away with it either way.

> The rest of your (snipped) post is qute a 
> good explanation, though rather abstract in its wording.

Abstraction is good.  Programmmers pursue it relentlessly, for good
reason.

Art

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