this post was submitted on 25 Aug 2023
20 points (95.5% liked)
Lemmy
12572 readers
3 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
select person.id,name,local,local_user.email from person join local_user on person.id = local_user.person_id where person.id =2;
id | name | local | email
----+-----------+-------+---------------------
2 | BlueEther | t | firstname@lastname.nz
Email is only available for local users and only if filled in on the signup form