> table1 have fields of 2
> fld1    fld2
> aa        7
> bb        8
>
> table2 have fields of 2
> fld1   fldx
> aa      1
> aa      3
> aa      8
> bb      2
>
> table3 have fields of 2
> fld1   fldy
> aa      k
> aa      b
> aa      c
> bb      x
>
>
> i want to make following table using query.
> fld1   fld2      fldx   fldy
> aa      7          1      k
> aa      7          3      b
> aa      7          8      c
> bb      8          2      x
>
>
> how query???
>
>
> *** Sent via Developersdex http://www.developersdex.com ***