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
>

DA Morgan wrote:
> 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)