3 ms·
> If a has 3 columns and b has 5 columns, then the "output table" will have 8 (3 + 5) columns. The records contained in this combined table reference are those
by ExpiredLink 13y ago
> If a has 3 columns and b has 5 columns, then the "output table" will have 8 (3 + 5) columns. The records contained in this combined table reference are those of the cross product / cartesian product of a x b.
This is where the easy steps become hard for real noobs.
- pbhjpbhj 13y agoA graphical example of a Cartesian join - http://web.utk.edu/sas/OnlineTutor/1.2/en/60477/m71/m71_3.htm http://web.utk.edu/sas/OnlineTutor/1.2/en/60477/m71/m71_3.ht....
- julochrobak 13y agohere are some other graphical illustrations of the operators from relational algebra - http://bandilab.org/bandicoot-algebra.pdf http://bandilab.org/bandicoot-algebra.pdf It's focusing on bandicoot language, but concepts are taken from the relational algebra. It should match the logic of SQL.