Hi Rob,

Didn't you hear they added a new feature that makes it slower to
compare strings to 'T' than 'F'.

No, just kidding.

Starting to get beyond my experience here, but have you had a look at
something like IBPlanalyzer to see how many records are being hit from
each table? Is there an index available for the join to take place
efficiently? How many records are in each of the tables?

Obviously doing comparisons on non-indexed fields is going to be a
recordset scan of some form, so you need to know how many records are
being hit to decide to return 208 of them.

Adam