[Apprentice123]

How can I make a junction where-clause in sql, with and?

It's correct:

" WHERE aux1 =" & VAR1 & "and aux2=" & VAR2 

?

[Martyr2]

That is correct if you are looking for all rows that match aux1 = var1's value AND aux2 = var2's value. To do joins through keys you can also do...

where table1.field = table2.field and table2.field2 = 'some value'

Here is one where we do an AND and an OR...

where (table1.field = 'some value' and table1.field2 = 'some other value') OR table1.field3 = 'yet another value'

Hopefully this is answering your question.