Slash Boxes

All the Perl that's Practical to Extract and Report

More | Login | Reply
Loading... please wait.
  • An outer join is a join on a field which contains all rows from the left, right or both tables (left/right/full outer join, respectively). Wherever a row has to be included in the result set but could not be joined to a row in other the table, the other table’s column’s in that result set row are filled with NULLs.

    A join that produces a Cartesian product is called a cross join. You can denote it explicitly in modern SQL dialects by saying something like

    INSERT INTO perpetrators ( name )

  • You are right, the technique is the cross join. I rarely use anything other than inner joins, so I had forgotten the term. I've corrected the essay. Thanks!