; Tore.
>
> - Original Message -
> From: "Ramesh Pillai" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 27, 2003 10:36 PM
> Subject: Inner join question!
>
>
> > All,
> >
> > I have two tables like the fol
ursday, February 27, 2003 10:36 PM
Subject: Inner join question!
> All,
>
> I have two tables like the following
>
> table A
> date num1 num2 time
>
> table B
> date num1 num2 time
>
> When I run a query like the following
>
> select * from A as a inner j
All,
I have two tables like the following
table A
date num1 num2 time
table B
date num1 num2 time
When I run a query like the following
select * from A as a inner join B as b
on a.num1 = b.num1 and a.date=b.date and a.num2=b.num2
and a.time=b.time
I am getting the results repeated 4 times, co
