Help for this page

Select Code to Download


  1. or download this
      select id, name from fileone where id in (select id from filetwo)
  2. or download this
    SQL ERROR: Bad table or column name 'select id from f2' has chars not alphanumeric or underscore!
  3. or download this
    #! /usr/bin/perl
use strict;
...
$dbh->{csv_tables}{f2}{col_names} = [qw(id)];

my $d = $dbh->selectall_arrayref('select id, name from f1 where id in 
+( select id from f2 )', {});