Sign in or Create an account
Charles Nadeau
delicious
bookmarked a page on delicious
1 hour ago - Link
Last.fm
loved two songs on Last.fm
yesterday at 11:54 am - Link
yesterday at 11:54 am - Link
delicious
bookmarked a page on delicious
yesterday at 11:14 am - Link
-- IN doesn't get correct results. -- That's because of how IN treats NULLs and the Three-valued logic -- NULL is treated as an unknown, so if there's a null in the t2.t1id -- NOT IN will return either NOT TRUE or NOT UNKNOWN. And neither can be TRUE. -- when there's a NULL in the t1id column of the t2 table the NOT IN query will always return an empty set. SELECT t1.* FROM t1 WHERE t1.id NOT IN (SELECT t1id FROM t2) -- NOT EXISTS gets correct results SELECT t1.* FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 WHERE t1.id = t2.t1id) - Charles Nadeau
delicious
bookmarked a page on delicious
delicious
bookmarked a page on delicious
Thursday at 2:37 pm - Link
Last.fm
loved a song on Last.fm
Last.fm
loved a song on Last.fm
Google Reader
shared 11 items on Google Reader
Google Reader
shared three items on Google Reader
Google Reader
shared 34 items on Google Reader
Google Reader
shared seven items on Google Reader
Tuesday at 6:08 am - Link
Tuesday at 6:08 am - Link
1 2 3 4 5 6 7 8 9 Older »
Tip: Now you can add FriendFeed to your blog with our new customizable FriendFeed widgets!
Other ways to read this feed: Feed