Page 1 of 1

Db2 fetch all customer details

PostPosted: Wed Aug 26, 2020 8:11 pm
by Neha992
I have table as below
Table 1:customer table. It stores customer status
Say customer-number
Customer-status

Table 2 : Customer-account
It stores accounts associated with a customet
Say customer-number
Account-number

Table 3:account table
It store account status
Say account number
Account status

I need to fetch all customers whose status is f and all accounts associated with it have status s
Can anyone help me with query.

Re: Db2 fetch all customer details

PostPosted: Thu Aug 27, 2020 9:55 pm
by prino
Ask your PHB to send you on a Db2 course.

Re: Db2 fetch all customer details

PostPosted: Fri Aug 28, 2020 11:07 pm
by sergeyken
What exactly do you know about such thing as “(relational) database”?

Re: Db2 fetch all customer details

PostPosted: Fri Aug 28, 2020 11:17 pm
by Neha992
If our could have helped it would have been better.. Learning can be done at an stage

Re: Db2 fetch all customer details

PostPosted: Sat Aug 29, 2020 12:58 am
by Robert Sample
If our could have helped it would have been better.. Learning can be done at an stage
This is a HELP forum, not a WRITE-THE-CODE-FOR-YOU forum. If you posted your SQL code and asked what was wrong with it, you would get a lot more help. But the way you posted it sounds like you know NOTHING about SQL and want somebody to write the query for you, which is not the purpose of this forum.