Help for this page

Select Code to Download


  1. or download this
    use MSSQL::TableReferences;
    
    ...
                         } 
                       ]
        };
    
  2. or download this
        # get the first relationship
        my $firstrel = shift @{$refs->{related}};
    ...
            ON tt.person_id = ot.person_id
           AND tt.week_id = ot.week_id
    
  3. or download this
        my_table        => mt
        my_other_table  => mot
        fred            => f
        dbo.fred        => f   # note that table prefixes are ignored
    
  4. or download this
        my_table        => mt
        mother_table    => mt1
    
  5. or download this
    package MSSQL::TableReferences;
    use strict;
    ...
    
    1;
    __END__