tabel 1 minus tabel2 where nr =5 skal give en combo

Kan du ikke bruge en modulus sætning i stil med denne:

SELECT [tal] Mod 5=0 AS udtryk1
FROM Tabel1
WHERE ((([tal] Mod 5=0)=-1));

SELECT [tal] Mod 5 AS udtryk1
FROM Tabel1
WHERE ((([tal] Mod 5)=0));

der jo 2 where dele .. i SQL

min tabel 1 ikke indeholde alle de tal der i forvejen er i table 2 (såfremt de begge har et given kriterie)

dvs
select * from tabel1 where not tal=(tal where kriterie=1)

select * from tabel1 t1
where t1.runde=5
and t1.runde not in (
  select t2.runde from tabel2 t2)

nope virker ikke.

kan jeg ikke bare gøre det så alle dem der er i min combo2 ikke er i min combo1

can you give an example of the data in both tables and waht you want in the result?

just a wild guess because I'm not sure what your after


select * from tabel1 where tal NOT IN (SELECT tal FROM table2 where runde <> 5)

Once again he made a miracle 
you are my Guru terry

Så fik du jo også løsningen hele 2 gange  :o)

kunne ikke få din løsning til at virke!!!

men i kan vel dele

well I may be wrong but I dont think the SQL 03/07-2008 12:58:47 is the same as
the SQL I gave 03/07-2008 14:52:15.

The SQL 03/07-2008 12:58:47 assumes that there is a field named runde and only those with value 5 are to be in the result. And only those in the result must NOT exist in table2. So in the end (if I am not mistaken), only those with runde = 5 will be found and ONLY if not exist with runde = 5 in table2.

The SQL I gave finds ALL records in table1 which do not exist in the result from the sub select.