Hello gang,
I'm trying to create a view using a sub-select, whilst VFP allows me to create it in code from the command window, it throws the error "SQL to complex" if I try to modify it in the database designer, all I'm trying to do is select records from a lookup table that are not in another based on a common field, this is how I've tried to do it

Select * ;
from elemtype ;
where elemtype.claim_elem_code not in ;
(Select elem_code from elements where elements.clm_ref = ?thisform.clm_ref)

the actual code works fine, is there an easier / better way to do this??


Regards

Pete Kane