It works!!! Thanks but how does it work? Sorry and another thing, I also need to make sure, in the query, that when comparing rdxls_banned.data and rdxls_groups.group_name, rdxls_banned.data - the same record must also satisfy, rdxls_banned.type='group'. How do i do that?
Last edited by RadixDev on Tue Jul 20, 2004 6:22 pm, edited 1 time in total.
LEFT JOIN looks at the data to it's left, heh, and if it doesn't match, all fields that'd normally be set, are set to NULL. So you filter it where those rows are null.. where the tables don't match..
RadixDev wrote:It works!!! Thanks but how does it work? Sorry and another thing, I also need to make sure, in the query, that when comparing rdxls_banned.data and rdxls_groups.group_name, rdxls_banned.data - the same record must also satisfy, rdxls_banned.type='group'. How do i do that?
SELECT t1.`group_name` FROM `rdxls_groups` t1 LEFT JOIN `rdxls_banned` t2 ON t1.`group_name` = t2.`group_name` AND t2.`type` = 'group' WHERE t2.`group_name` IS NULL;
I'm sorry, I didn't notice that it was so old. I actually got to it from a list of "useful posts" and just read that it was from "March" but didn't notice the year . I apologize.