sqlsætning til at sammenligne 2 felter

You can start by finding those which are in both with something like this

SELECT * FROM A WHERE kode IN(SELECT kode FROM B)


and then maybe something like this to find how many are in both


SELECT count(*) FROM (SELECT * FROM A WHERE kode IN(SELECT kode FROM B))

That first SQL isnt quite right :o)

SELECT * FROM tbl1 WHERE felta IN(SELECT feltb FROM tbl1)



another idea would be to make a query where you include the table twice and make a join between fielda and fieldb

Hi Terry
SELECT * FROM tbl1 WHERE felta IN(SELECT feltb FROM tbl1)

did the job - thanx

:o)