Mehere Tabellen und Join - Schreibschutz?

[RavenIV]

Solltest Dir vielleicht dann den Cross Join anschauen.

Zitat:

Cross join (Cartesian product)
Cross join, or the Cartesian product of two tables, can be defined as another (rather virtual) table that consists of all possible pairs of rows from the two source tables. Returning to our customer phone example in the nonequijoin section of this chapter, the cross join of the CUSTOMER and PHONE tables returns results very similar to what we've got on Figure 8-2 except it would also return the valid customer/phone combinations, excluded from the previously mentioned nonequijoin.

SQL99 standard syntax
This query will return all possible combinations of customer names and phone numbers by performing cross join of CUSTOMER and PHONE tables:

SELECT cust_name_s,
phone_phonenum_s
FROM customer CROSS JOIN
phone