Joining every row from 1 table to every row from another

Hello!


Answer is propably simple, but I'm struggling and can't solve this
problem. I have two tables:



Table GARMENT

STYLE_NO DESCRIPTION LABOUR_COST NOTIONS
1 Trousers 18 xxx
2 Long Skirt 15 Zip/ 1 cm off
3 Shorts 10 Zip/ Clip



Table MATERIAL

MATERIAL_NO FABRIC COLOUR PATTERN COST
1 Silk Black Plain 7
2 Silk Red Abstract 10
3 Cotton Yellow Stripe 3



The thing is to estimate costs of making any garment with any
materials. I need to join all garments to all materials, like

STYLE_NO DESCRIPTION (....) METERIAL_NO
1 XXX 1
1 2
1 3
2 1
2 2
2 3
3 1
3 2
3 3


and so on.. Could anyone please help me with this by giving some
examples of Oracle or MySQL query? Many thanks in advance!

Greetings
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ą.
.