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
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
Well I had started my post before yours hit.	by maceogan	2006-11-19 12:55:59
Not sure I read his question as what you two are describing though. If that is what he wants I would probably do something along the lines of the following SELECT TableA.ID, TableB.ID FROM TableA FULL OUTER JOIN TableB ON TableA.ID=TableB.ID That will return everything from both tables. If you only wanted the uncommon elemnents then you could add: WHERE TableA.ID = NULL or TableB.ID = NULL I am trying to find him a decent link that discusses joins. So far I have found this.
[ Reply ]
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.)