SQL query help

[adrian_quah]

please help me with this. i am finding for an SQL query that can

select from table 1, where (data in table 1 and table 2 are alike), but where it does not exists in table 2 and only exists in table 1.

thanks real lot..

[jweissig]

select from table 1, where (data in table 1 and table 2 are alike), but where it does not exists in table 2 and only exists in table 1.

hi,

you need to do this "select * from table1, table2 where table1.name = table2.name". If you are using MySQL you might want to check out checking for NULL's or you might also want to check for information that does not match.

I am a little unsure what you mean by this "but where it does not exists in table 2 and only exists in table 1"?

Can you please explain.

• Justin

[adrian_quah]

thanks Justin, what u suggested was

SELECT users_login.Login FROM users_access_rights, users_login WHERE users_login.Login = users_access_rights.Login ORDER BY users_login.Login"

actually i'd like it to retrieve from users_login.Login when a user e.g. 'admin' exists on users_login but not on users_access_rights.

Thanks again 😃

[adrian_quah]

so any suggestions guys?

[Lars_Berg]

SELECT users_login.Login FROM users_login  left outer join  users_access_rights on users_login.Login = users_access_rights.Login 
where users_access_rights.Login is null
ORDER BY users_login.Login

[adrian_quah]

Thanks man! it works!! now, gonna learn more abt joining of tables in SQL queries!