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 |
|
|
|