Problem with SQL statement

From: Tan Keok Tay <fbap7355_at_leonis.nus.sg>
Date: 1997/08/21
Message-ID: <5tgaiu$p0g@nuscc.nus.sg>#1/1

Hello,

        I have the following problem.
Imagine the data as follow.

Field1	Field2	Field3
-----	-----	-----
P1	P2	P3
P2	P3	P6
P3	P1	P2
P7	P2	P1
P1	P3	P2
P2	P7	P3
P1	P2	P3
p3	P4	P6
P8	P3	P1


:

:                      (1000 records)

I would like to select a certain number say 200 out of some many with the following order :
P3 , P2 , P1 .

ie .

P3	P2	P1
--	--	--
P3	XX	XX
p3	XX	XX
XX	P2	XX
XX	P2	XX
XX	P2	XX
XX	XX	P1
XX	XX	P1
XX	XX	P1
XX	XX	P1   , where XX= can be anything

Any Body has a simple query to do this ?? Have tried using UNION, but it doesn't work .

---

Aquarius Received on Thu Aug 21 1997 - 00:00:00 CDT