Plz, what is the most "correct" method - Mailing list pgsql-sql

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