troubleshooting Question

db2 sql : join in both directions

Avatar of bobdylan75
bobdylan75Flag for Afghanistan asked on
DB2IBM System i
5 Comments1 Solution540 ViewsLast Modified:
Hi,
need to have a TYPE OF JOIN that connects to both records in the table on the left that those in the right table,
even if they do not match each other..
in example:
in the left table I have 3 records,
1
3
5

in right table I have 3 records,
1
4
6

the result join table has to have 5 elements:
1
3
4
5
6

(I dont need a UNION sql because my real table has more fields different in the two tables)
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros