Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Fun with SQL: integer runs 2 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Cool!

    I think I must review what the "CROSS JOIN" does in my SQL manual... :-)
    Thanks for sharing.

    • CROSS JOIN is simply an explicit way to request the standard cartesian product.

      sqlite> CREATE TABLE tbl (num INTEGER);
      sqlite> INSERT INTO tbl VALUES (  1);
      sqlite> INSERT INTO tbl VALUES (  2);
      sqlite> INSERT INTO tbl VALUES (  3);
      sqlite> SELECT t1.num A, t2.num B FROM tbl t1 CROSS JOIN tbl t2;
      A           B
      ----------  ----------
      1           1
      1           2
      1       

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.