List: | General Discussion | « Previous MessageNext Message » | |
From: | Angelo Zanetti | Date: | June 8 2005 4:06pm |
Subject: | LEFT JOIN? | ||
View as plain text |
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
Thread | ||
---|---|---|
• LEFT JOIN? | Angelo Zanetti | 8 Jun |
• Re: LEFT JOIN? | SGreen | 8 Jun |
• Re: LEFT JOIN? | Angelo Zanetti | 8 Jun |
• Re: LEFT JOIN? | Michael Stassen | 8 Jun |
• Re: LEFT JOIN? | Angelo Zanetti | 8 Jun |
• Re: LEFT JOIN? | SGreen | 8 Jun |
• Re: LEFT JOIN? | Alec.Cawley | 8 Jun |
• Re: LEFT JOIN? | Michael Stassen | 8 Jun |
• Re: [SOLVED]LEFT JOIN? | Angelo Zanetti | 9 Jun |
• Enhance a query | Harish Gabbita | 27 Jun |
• Re: Enhance a query | SGreen | 27 Jun |