Posted by: Ghiraunla May 2, 2017
Login in to Rate this Post:
0
?
Hi SQL Gurus,
I need to join two tables say Table I and Table W
Table I is like below
Numbers Values
1 A
1 B
2 C
3 D
Table W is Like Below
Numbers Boolean
1 Yes
1 Yes
2 Yes
3 Yes
I need to query to join Table I and W where Boolean value is Yes in Table W but there is no D in Table I in Oracle database. The answer would be
Number
1
2
Can someone help me get a query?
I need to join two tables say Table I and Table W
Table I is like below
Numbers Values
1 A
1 B
2 C
3 D
Table W is Like Below
Numbers Boolean
1 Yes
1 Yes
2 Yes
3 Yes
I need to query to join Table I and W where Boolean value is Yes in Table W but there is no D in Table I in Oracle database. The answer would be
Number
1
2
Can someone help me get a query?