select table1.*,table2.*,table3.*,table4.* from table1
inner join table2
inner join table3
inner join table4
correct, it is cartesian product, not cross product. thank you, varmadba :)
True, the cardinality is just the total product of the cardinalities of all involved tables. But this might be ok to him. So he would learn how to figure out the essential rows manually doing true handiwork.
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...