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

Hrm, SQL query help.	by abaron	2007-05-09 13:38:44
One quick shot at it.	by CynicalRyan	2007-05-09 13:44:15
actually...	by ricochetv1	2007-05-09 13:50:35
We use this kind of query here at work a lot... Keep in mind for this thing, that the two fields must be of the SAME type or it won't work. basically, it goes like this: select * from table1 where field_with_string NOT IN (select field_with_string from table2)
[ Reply ]
NOT IN () is BAD!!!!!!	by merlin	2007-05-09 13:51:40
I guess...	by ricochetv1	2007-05-09 13:57:45
Yes, true, but in general outer joins outperform	by merlin	2007-05-09 13:59:37
IN() is quite useful in some circustances though,	by Scirocco	2007-05-09 14:04:27
Excellent point. Let me rephrase:	by merlin	2007-05-09 14:06:31
It's actually a case of mis-optimitization.	by staticsan	2007-05-09 16:09:11
JOINs are pretty basic SQL, IMO (n/t)	by CynicalRyan	2007-05-09 14:00:14
Yes, but they can get complex very quickly.	by merlin	2007-05-09 14:03:17
Tell me about it..	by CynicalRyan	2007-05-09 14:04:00

[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.)