By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Need Urgent Info Regarding Retreiving Values From Child Table

P: 9
HI ALL
I AM USING DB2 8.1 AND I HAVE TWO TABLES
PARENT TABLE
1)CODE IS PRIMARY KEY

CODE CODE_DESC CATEGORY
----------- ---------------------------------------- ---------- ------------
1 SelectByPlan A
2 SPT A
3 SP A
4 SR A
5 Internal A
7 TPDCategory A
2)CHILD TABLE
ID PAGE_NM CD
-------------------------------------------------------------------
118 Test Subpage234 -
243 Test -
258 testing 1
HOW IT IS POSSIBLE THE CHILD TABLE HAVING THE FOREIGNKEY VALUE WHICH IS NOT IN THE PARENT TABLE.
THEISSUE IS:WHILE RETREIVING THE VALUES FROM CHILD TABLE WITH CONDITION CD<>1 IT RETURNS NOTHING
Feb 22 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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