can I optimize this query?

Hey all,
I have 2 tables:
Profiles(id).
Relationships(id,friend_id,befriender_id).

friend_id and befriender_id represent profiles ids.

I want to find all the profiles that are neither friends neither befrienders with a given profile.

this is the query I use with profile id=1:

select * from profiles
  where profiles.id not in
  (SELECT profiles.id FROM profiles INNER JOIN relationships ON profiles.id = relationships.befriender_id WHERE
(relationships.friend_id = 1 ))

and profiles.id not in
(SELECT profiles.id FROM profiles INNER JOIN relationships ON
profiles.id = relationships.friend_id WHERE
(relationships.befriender_id = 1 ));

is there a better, faster way to do so?

thanx in advance

Pat

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek