Hi All,
I'm trying to turn this...
select DISTINCT(Email) from lsql_Users WHERE ReceiveMail = 'Yes';
into "something" like this - have I done the DISTINCT bit correctly??
my $cond = new GT::SQL::Condition;
$cond->add(ReceiveMail => 'Yes');
$sth = $DB->table('Users')->select($cond, ['DISTINCT(Email)']);
Thanks
Regan.
I'm trying to turn this...
select DISTINCT(Email) from lsql_Users WHERE ReceiveMail = 'Yes';
into "something" like this - have I done the DISTINCT bit correctly??
my $cond = new GT::SQL::Condition;
$cond->add(ReceiveMail => 'Yes');
$sth = $DB->table('Users')->select($cond, ['DISTINCT(Email)']);
Thanks
Regan.