From: PipHans <piphans@hotmail.co>
To: pgsql-sql@postgresql.org
Subject: Plz, what is the most "correct" method
Date: Wed, 10 Sep 2003 18:01:55 +0200
Message-ID: <3f5f4af1$0$48889$edfadb0f@dtext02.news.tele.dk> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: piphans@hotmail.co
Subject: Re: Plz, what is the most "correct" method
In-Reply-To: <3f5f4af1$0$48889$edfadb0f@dtext02.news.tele.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox