|
Posted by MORALBAROMETER on 10/20/06 15:19
Hi alll
I have these tables below with 3 fields each. I want to get the record
in table 1 whose field number value is same in table 2 but field number
2 on both tables are different. I mean i want the record
1500 800 2. Insight: Table 1 is modules ordered and table 2 is modules
delivered. I want to get 1500 800 2.beacuse module 800 was ordered but
in table 2 module 503 was delivered. can some one help me with a join
nice weekeend
Table 1
10 5012 10
1600 502
100 502 3
1500 800 2
Table 2
1500 503 1
1400 4000
100 502 10
100 600
100 502 3
Navigation:
[Reply to this message]
|