LEFT JOIN?

[Angelo Zanetti]

Hi guys.

I'm having a problem deciding whether a left join is suitable for what i
want to do.

I have two tables

A Users
-userID
-isactive

B BuddyList
-userID
-buddyID

what i want to do is to get all the users from A that don't exist as a
buddyID for a user (buddyList) also the user must be active (isactive=1)

but i cant get the correct result.
Is the LEFT JOINcorrect for this operation or should i try using the NOT
EXISTS command?

TIA

Angelo