sql select challenge

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
----------------------------------------------------------------

Browse pgsql-general by date

  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