Forum Moderators: coopster
is my query and it will return with the results from table mos_users as many times as you have some1 in mos_Mediaman_Acces but i dont want this i want 1 result without the people in the table mos_mediaman_acces.
TY for your help IS it not clear? ask and i will speak :D
Is this what you are looking for?
select mos_mediaman_acces.userid, mos_users.id, mos_users.username from mos_mediaman_acces, mos_users WHERE mos_mediaman_acces.userid==mos_users.id;
Otherwise, a bit longer, but you can:
1/ Do a query to get the id of mos_mediaman_access and create an array.
2/ Do a query of all your user and create an array
3/ Work with array (difference, union, etc...) to get what you want
They are great examples and explanation, and also some tips on how to use GROUP_BY.
Also, post an example on how your tables look like so that I can understand the structure you are having.
Good luck
Tahts all :P
Let's hope that someone else will help you out on this one...
maybe if you could explain what it is you are trying to select as opposed to a query that doesn't work it would help us to figure it out.
select
mos_users.id, mos_users.username
from
mos_users
where
mos_users.id NOT IN
(select distinct userID from mos_mediaman_access)
It returns all mos_users who are not in mos_mediaman_access.
Jakar you should have read my posts before it is clear for other people also thanks anyway :D
