Select Code to Download

SELECT M.msg_id, 
       SND.firstname as snd_fname, SND.lastname as snd_lname,
...
join USERS as SND on M.msg_from = SND.usrid
-- and REC as the alias for the recipient
join USERS as REC on M.msg_to   = REC.usrid

$data->execute();
my $data_check = $data->fetchall_arrayref();
...
         join(" ", $snd_lname, $snd_fname), 
         join(" ", $rec_lname, $rec_fname);
}

$data->execute();
my $data_check = $data->fetchall_arrayref();
...
         join(" ", $row->{snd_lname}, $row->{snd_fname}), 
         join(" ", $row->{rec_lname}, $row->{rec_fname});
}