b0010100 made the suggestions about stepping through and checking whether or not tables were null. I'm not at all familiar with the syntax he was using (I had initially assumed that it was just in pseudocode). I was able to follow his general logic to obtain the visual basic code that I was looking for.
The inner joins worked exactly like I wanted them to and I'm so happy I didn't have to use any outer joins.
I really appreciated...
akhos1
Last Activity: Aug 2 '10, 08:47 PM
Joined: Jul 26 '10
Location:
-
My apologies, I didn't realize I was hijacking anyone's post.
In any case, thanks a bunch guys! It took me a while to finish debugging, but I just got done today and it works like a charm. Excellent suggestions!...Leave a comment:
-
WOW, this looks great! I'll try it out this afternoon and I'll let you know how it works.
Thanks a million!...Leave a comment:
-
Maybe I'm not being clear. Let's make a random assumption that table B is the blank table. An inner join with tables A and B would yield no results, therefore the union with table AB and table C would show all values in table C.
The code you put up there works perfectly, but I want to find out how to modify it such that any table may be null at any time, but I can still find matched values in the tables that actually are populated....Leave a comment:
-
It is my understanding that outer joins return ALL values of one of the tables (i.e. left join returns all values for the left table and shows matching values between tables, even if the right table is null and vice versa for right join).
My issue is that any table can be empty. Either table 1 or table 2 or table 3. The outer join would work fine if I knew which table would be empty, but I don't. I'm trying to avoid outer joins all together....Leave a comment:
-
Full Outer Joins
I had a similar question.
I was wondering how I should approach a situation where any one of the three tables can be null.
Your suggestion works if the third table is the only table that is null. How do I alter this so that accommodations can be made for the fact that any one of the tables may be blank at any given time?
Thanks!
** Admin Edit **
This thread was created as a result of a hijack...
No activity results to display
Leave a comment: