|
Posted by DA Morgan on 10/20/06 15:51
MORALBAROMETER wrote:
> 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
>
Write a statement where:
field1 = field1
and
field2 <> field2
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Navigation:
[Reply to this message]
|