Groups | Search | Server Info | Login | Register

Groups > comp.databases > #87

joining tables and the order changes

Show all headers | View raw

Hi

I have 2 tables Dealsbasket and Product

Deals Basket :

DealNumber
DealProduct


Product :

product code
product description

When i display records from deal basket for a specific deal number it
displays the record fine. When i create a view and link the 2 tables
by product code so i can display description the order of records
change????

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

thanks

Back to comp.databases | Previous | Next — 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