Re: [GENERAL] sql select challenge

2000-06-12 Thread davidb
ssage- From: Travis Bauer <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, June 12, 2000 8:20 AM Subject: [GENERAL] sql select challenge >Let's say I have two tables with the follwing data: > >Table_X > >A | B >- >1

[GENERAL] sql select challenge

2000-06-12 Thread Travis Bauer
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