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.
 Full
 Abbreviated
 Hidden
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 )
    SELECT
        ( p.name & ' #' & i.index ) AS name
    FROM perpetrators p
    CROSS JOIN indexes i
    WHERE
        p.name IN ( "John Doe",  "Jane Doe" )