Hi,
GT::SQL does not support for sup-query, but you can do something like this instead:
my $list = $DB->table("Insured")->select('Carrier', { PatientID => 'xxxxxxxxxxx' })->fetchall_arrayref;
my @ids = map $_->[0], @$list;
my $results = $DB->table('Select')->select(GT::SQL::Condition->new(Carriers => 'NOT IN' => \@ids))->fetchall_hashref;
# For debugging
use Data::Dumper;
print "<pre>".Dumper($results)."</pre>";
Hope that helps.
TheStone.
B.
GT::SQL does not support for sup-query, but you can do something like this instead:
my $list = $DB->table("Insured")->select('Carrier', { PatientID => 'xxxxxxxxxxx' })->fetchall_arrayref;
my @ids = map $_->[0], @$list;
my $results = $DB->table('Select')->select(GT::SQL::Condition->new(Carriers => 'NOT IN' => \@ids))->fetchall_hashref;
# For debugging
use Data::Dumper;
print "<pre>".Dumper($results)."</pre>";
Hope that helps.
TheStone.
B.