I have joined two tables as below correctly
SELECT m.id as mid, c.id as cid FROM members m inner join companies c on m.id=c.id
and then I wanted to add a 3rd table also, but I can not get it working.
SELECT m.id as mid, c.id as cid, u.id as uid FROM members m inner join companies c on m.id=c.id inner join users u on m.id=u.id
What am I missing here?