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
You want an outer join.	by maceogan	2005-03-10 11:32:36
'Outer' is optional (n/t)	by Arachnid	2005-03-10 11:37:02
Oh, and that'll only match items that're in the	by Arachnid	2005-03-10 11:38:42
left table. If you want a row for every item that's in both tables or either one table, you want a FULL [OUTER] JOIN. On the other hand, if all you want is a list of the union of the IDs from both tables, you could just use "SELECT t1.id UNION SELECT t2.id".
[ Reply ]
Yes	by maceogan	2005-03-10 11:48:13
I think what he is looking for is	by Spisefisken	2005-03-10 11:49:01
Makes me wonder if anybody reads everybody's posts	by williamashbless	2005-03-10 11:53:08
You mean like this	by Spisefisken	2005-03-10 11:59:07
And btw I read your post afterwards	by Spisefisken	2005-03-10 12:00:05
Oh, oops! :D (n/t)	by williamashbless	2005-03-10 12:01:33
Well I had started my post before yours hit.	by maceogan	2006-11-19 12:55:59
Correction.	by maceogan	2005-03-10 12:07:49
Oh yeah	by Spisefisken	2005-03-10 12:09:23
Now we just need Amish to clarify what he wanted. (n/t)	by maceogan	2005-03-10 12:11:19

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