Re: Joining every row from 1 table to every row from another
- From: radnor <radnor@xxxxxxxxxxxxxx>
- Date: Thu, 24 Nov 2005 21:17:01 +0000
On Thu, 24 Nov 2005 12:37:34 -0800, Bill Karwin <bill@xxxxxxxxxx>
wrote:
>SELECT GARMENT.*, MATERIAL.MATERIAL_NO
>FROM GARMENT, MATERIAL;
>
>This should work in Oracle, MySQL, or any other system that supports the
>most rudimentary features of SQL.
>
>Regards,
>Bill K.
Doh, I really need some rest. I've been making some subqueries to get
this instead of reminding simplest way. Thank you!
Regards
Kamil
jak zawsze pozdrawiający
radnor
--
O (=> useer(maupa)go2.pl 05011474(maupa)napier.ac.uk
)/\_,_[__] GG: 5004286 ICQ: 45007845
T>_ [ ] Wariat: człowiek cierpiący na dużą niezależność intelektualną.
.
- References:
- Joining every row from 1 table to every row from another
- From: radnor
- Re: Joining every row from 1 table to every row from another
- From: Bill Karwin
- Joining every row from 1 table to every row from another
- Prev by Date: Re: Joining every row from 1 table to every row from another
- Next by Date: Re: Information in SQLException
- Previous by thread: Re: Joining every row from 1 table to every row from another
- Index(es):
Relevant Pages
|
|
