---+
5 rows in set (0.00 sec)
mysql>
> From: "Jeff Habermann" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Help with JOIN query
> Date: Thu, 28 Mar 2002 17:16:05 -0800
>
> What i want to do seems simple, but i can not for the life of me figure
out
Jeff,
> What i want to do seems simple, but i can not for the life of me
figure out
> how to do it.
> Tables: These tables are not related in any way.
>
> A
> --
> 1
> 2
> 3
> 4
> 5
>
> B
> --
> 1,Bob
> 3,Jack
> 7,Janet
> 8,Gary
> 9,Kelly
>
> I would like to combine tables A and B with a SELECT
What i want to do seems simple, but i can not for the life of me figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get this:
SELECT
--
1,1,Bob