I wonder if someone could point me in the right direction: -

I am linking from TableA to TableB

There is an index on Table B of
Field1
Field2

Field2 exists on both tables so that's the easy bit.

The problem is TableB.Field1 is a value that I know but I don't know how to get it into the query NB It doesn't exist on any other table.

In short I want the SQL to look something like
Where TableB.Field1 = "Fred"             /* Not sure how to do this bit */
     and TableB.Field2 = TableA.Field2 /* This is the easy bit */

I've not explained it very well but any hello would be much appreciated.

If I've posted in the wrong section, let me know.

Thanks.

Thanks, I'll give it a try.