IBM Mainframe Forum

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.

Ask your PHB to send you on a Db2 course.

What exactly do you know about such thing as “(relational) database”?

If our could have helped it would have been better.. Learning can be done at an stage

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.