Viewing 2 posts - 1 through 3 (of 3 total)
try like this
if active is from t1
SELECT *
FROM ordercard T1 where receipt in (select receiptnr from ordernew)
...
May 23, 2008 at 11:11 pm
#819967
check the duplicates in T2.
Some ids / values which you are using for join may have repetition in T2
May 23, 2008 at 2:53 am
#819542