Hi again all,

Table J is a pure junction table between Table A and B. All J has is it's own integer pkey plus an fkey to A and an FKey to B

How can I write a select statement to select all combinations of A and B that are NOT currently in J? Example below:

A
---
1
2
3

B
---
4
5
6

J
---
1 4
1 5
1 6
2 4
3 4
3 5

I want a select that will return
S
---
2 5
2 6
3 6

thanks!