0

Hello All,

I am facing a problem coming up with a SQL query for a certain issue:

Table 1
-------------------
Client ID|Name of Client|Customer Type|Account Type|
01| A |    AB        |      30      |
02| B |    AB        |      30      |
03| C |    CD        |      30      |
04| D |    CF        |      40      |


Table 2
-----------------
Argument|Switch|
AB30     |  Y  |
CD30     |  N  |
CF40     |  Y  |

Table 3
-------------------
ClientID|Name Of Client|External_Information|
01|A    | External A
02|B    | External B
03|C    | External C

Currently, I am trying to extract the information based on 3 different tables. I am suppose to extract the External Information from Table 3 based on 3 conditions

1) The Client ID must exist in Table 3 and Table 1
2) If the Client ID exist in Table 3 and Table 1, then we must check in Table 2 if the combination of Customer Type and Account Type (eg : For Client ID 01 , the combination would be AB30)
in Table 1 exist in Table 2 and if the Switch in Table 2 = "Y".

My current SQL would be :

select External_Information from Table_3 a where a.ClientID = (select ClientID from Table_1 where ClientID = a.ClientID);

This would solve Condition 1 , but for condition 2 I am not sure how we are able to do it within the same SQL query.

The expected result should be :

External_Information

External A
External B

Edited by gregarion

1
Contributor
1
Reply
11
Views
3 Years
Discussion Span
Last Post by gregarion
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.