|
View previous topic :: View next topic
|
| Author |
Message |
itmanand
New User
Joined: 18 Dec 2008
Posts: 24
Location: Newyork
|
|
|
|
Table 1
---------
Country region division amount
US 1001 01 300
FR 2001 01 100
IN 3001 02 200
JP 1002 01 500
Table 2
---------
Country region division division code
US 1001 01 T
FR 2001 01 P
IN 3001 02 P
JP 1002 01 T
Result
-------
Country region division amount
US 1001 01 300
JP 1002 01 500
Can someone help me to buid a query for this? The output of the 3rd table should be when country, region and division in two tables match and the division code is T. |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
| Code: |
SELECT *
FROM TABLE1 A
WHERE EXISTS(SELECT 1
FROM TABLE2 B
WHERE A.COUNTRY = B.COUNTRY
AND A.REGION = B.REGION
AND A.DIVISION = B.DIVISION
AND B.CODE = 'T') |
|
|
| Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
| An inner join of A and B on country, region and division with a condition division = 'T' would be better than a co-related query ... |
|
| Back to top |
|
|
|
|
