Hi,
Given 2 tables:
Table1:
id Auto,int,PrimKey
table2id int
txt nvarchar50
Table2:
id Auto,int,PrimKey
order int
The scenario: Table2.order defines how the table1.txt is should be ordered.
Table1.table2id contains the id of the order. This cannot be changed
How do I select all Table1.txt values but ordered by their corresponding
values of the table2.order field?
--
Thx,
PipHans
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 01-09-2003