CROSS JOIN

[PointsWell]

The ability to take n BO and cross join these to one table without manually finding each and creating individual rows.

I have multiple instances where the user creates 3 business objects which may have between 1 and n instances and then needs to be able to interrogate the combination at a later date. Can use views but the data is needed for reports at a later date and by persisting these it is easier to query.

eg

Manufacturer (Ford, GM)
Type (Sedan, SUV)
Colour (Red Blue)

produces

Code: Select all

Manufacturer Type  Colour
Ford         SUV   Red
Ford         SUV   Blue
Ford         Sedan Red
Ford         Sedan Blue
GM           SUV   Red
GM           SUV   Blue
GM           Sedan Red
GM           Sedan Blue