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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
