http://www.perlmonks.org?node_id=1186424


in reply to Re: Populating an array via a DBI call - simplified
in thread Populating an array via a DBI call - simplified

Great thread. Seems the answer to my question is as followed ---

my @accounts = @{$dbh->selectcol_arrayref("SELECT `UserName` FROM Acco +unt a, asscAccountAccountGroup aaag, asscRoleAccountGroup arag, Role +r WHERE a.Id = aaag.AccountId AND aaag.AccountGroupId = arag.AccountG +roupId AND arag.RoleId = r.Id AND r.Name = 'ROLE_REVIEWER'")}; print join("\n",@accounts);

Thanks again for pointing me in the right direction