FROM tableA A
INNER JOIN TableB B
ON A.eka = B.eka
You said earlier in the post that eka is the primary key of tableA. That
means that there can be only one row for which eka = 4.
Jacco Schalkwijk MCDBA, MCSD, MCSE
"mkarja" <com> wrote in message