JOIN

[Robert Kehl]

Hello,
I have the following problem, which could maybe solved by sql-join.

1. objective: get all combinations of 2 variables
2. example
---------------------------------

create table basis
(article Integer,
supplier VarChar(10) );

Insert into basis
Values(4711, 'A'),
(4712, 'B'),
(4712, 'C'),
(4712, 'D'),
(4713, 'C'),
(4713, 'E');

------------------------

3. following result is expected

combination_nr;article;supllier
1;4711;'A'
1;4712;'B'
1;4713;'C'
2;4711;'A'
2;4712;'B'
2;4713;'E'
2;4711;'A'
3;4712;'C'
3;4713;'C'
4;4713;'A'
4;4713;'D'
4;4713;'E'
5;4713;'A'
5;4713;'D'
5;4713;'C'
6;4713;'A'
6;4713;'D'
6;4713;'E'

Thanks in advance