UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

SQL Silly	by amish	2005-03-10 11:11:57
Wow, that made by brain hurt.	by amish	2005-03-10 14:09:14
I ended up using SELECT TableA.* FROM TableA WHERE (TableA.ID) Not In ( SELECT TableA.ID FROM TableA,TableB WHERE TableA.ID=TableB.ID); I think this is the same as some of the outer joins, but this made my brain hurt less and was one of the early posts. I'll certainly try out some of the simpler looking joins to see how they work! They may not be what I thought I wanted, but they might be something I should have :) Thanks for all your help! I haven't done anything but really simple SQL for a long time and one becomes rusty with the subtle things really quick.
[ Reply ]
w00t! Do I win a prize? :D (n/t)	by williamashbless	2005-03-10 14:16:59
Note: I haven't really properly gotten JOINs. (n/t)	by williamashbless	2005-03-10 14:39:07
If you are interested I can probably dig up	by maceogan	2005-03-10 18:35:20
Subselects are very inefficient	by Arachnid	2005-03-10 16:42:13

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)