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.