Re: JOIN / NOT JOIN differences

2008-04-19 Thread Baron Schwartz
Hi, On Wed, Apr 16, 2008 at 6:26 AM, Nacho Garcia [EMAIL PROTECTED] wrote: hi, i have this table *TABLE friends: *id_usr INT id_friend INT and i have a query in which i return friends from a given user and data related to each of them stored in some other tables. So i do

JOIN / NOT JOIN differences

2008-04-16 Thread Nacho Garcia
hi, i have this table *TABLE friends: *id_usr INT id_friend INT and i have a query in which i return friends from a given user and data related to each of them stored in some other tables. So i do this: SELECT F.id_friend, M.status, P.firstname, P.lastname, IF( UNIX_TIMESTAMP( ) -