From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | sql select challenge |
Date: | 2000-06-12 13:16:46 |
Message-ID: | Pine.GSO.4.21.0006120807470.14736-100000@mantaray.cs.indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Let's say I have two tables with the follwing data:
Table_X
A | B
---------
1 | Cat
2 | Dog
3 | Mouse
4 | Hat
Table_Y
C | D
---------
2 | Eat
4 | Book
I would like a select statement that joins these two tables to produce the
following. It lines up the rows one by one against one another simply by
the order they appear in the table, but not by any other criteria:
View_XY
A | B | C | D
----------------------------
1 | Cat | 2 | Eat
2 | Dog | 4 | Book
3 | Mouse | |
4 | Hat | |
Any ideas?
Thank you,
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | davidb | 2000-06-12 15:31:51 | Re: sql select challenge |
Previous Message | Bruce Momjian | 2000-06-12 02:07:36 | Re: [GENERAL] Book nearing final form |