Im kinda new to these relationship databases and joins and I cant figure this one out.
Basically I need to fetch users uuid's from the db that are in a meeting with my user and not to fetch my uuid.
I have three tables users, participants and meetings. Participants is the join table for many to many relationship between the two other tables. Atleast that is what I think it is.
The problem is that I cant combine the two queries that I have created and those two queries that I created are not the solution to this.
This gives me all the meeting id's that there are associated with my users.id:
select meetings.id as 'meetingId'
from users
inner join participants on participants.users_id = users.id and users.id = 1
inner join meetings on participants.meetings_id = meetings.id;
And this gives me the user that is associated with meetingId's that are fetched from the above query:
select users.username, users.uuid, meetings.id as 'meetingId', meetings.timestamp, meetings.description
from meetings
inner join participants on participants.meetings_id = meetings.id
inner join users on users.id = participants.users_id
and meetings.id = 2
and users.id != 1;
Try the following:
SELECT users.username, users.uuid, meetings.id as 'meetingId',
meetings.timestamp, meetings.description
FROM participants p1
inner join participants p2 on p2.meetings_id = p1.meetings_id
inner join users on users.id = p2.users_id
inner join meetings on meetings.id = p2.meetings_id
WHERE p1.users_id=1 AND p2.users_id<>1