469,273 Members | 1,688 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,273 developers. It's quick & easy.

Incorrect results using FULL OUTER JOIN in DB2 v8

In the example that follows, I am receiving an incorrect result set in the View. I am looking to get the FULL result set from View_LY and Table_TY. Instead, this View is returning the Common (Equi) records and records on Table_TY only. Missing the records on View_LY only. Any known problems with FULL OUTER JOIN in DB2 or am I missing something. Documentation all around is somewhat limited:

View: View_LY
Store (PK)
Product (PK)
Week (PK)
LY_Week
Sales_Units_LY

Table: Table_TY
Store (PK)
Product (PK)
Week (PK)
Sales Units TY

CREATE VIEW View_TY_LY AS
SELECT TY.Store,
TY.Product,
TY.Week,
LY.LY_Week,
LY.Sales_Units as Sales_Units_LY,
TY.Sales_Units as Sales_Units_TY
FROM Table_LY LY FULL OUTER JOIN View_TY TY on TY.Store = LY.Store and TY.Product = LY.Product and TY.Week = LY.Week
Aug 13 '07 #1
0 1606

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by paulus4605 | last post: by
reply views Thread by reneecccwest | last post: by
7 posts views Thread by alexcn | last post: by
1 post views Thread by Greg Stark | last post: by
2 posts views Thread by Pasquale | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.