Request on 2 tables

Need help Database
1

Hello,
i’m looking since 2 days the ways to extract, from 2 tables, user’s email.
i have:

table user:
unique id
email

table members:
members_unique_id (that linked user unique_id)
members_project_id

i got the project id from get_url path so my vision was to do :slight_smile:

do a search on members, members_project_id=get-url-path with that i get the rights members_id but i don,t find the way to get the user’s email from user’s table … i only get users unique id at the end …

So if somebody can help regarding my blocking point …

Regards

Olivier

2

@locordi you can change your “member” table :

  • members_user (as User type)
  • members_project_id

Then, do search for members’s members_user’s email (condition: members_project_id=get-url-path) → you will get directly user’s email that is associated to this project !

3

Fantastic this answer exactly what i would like to do ! Thanks a lot for your help

1 Like