>Hi,
>
>Sorry for the uncomplete message.
>
>You can loop all the fields in the table and generate a where staement.
>
>e.g
>
>FOR n = 1 to FCOUNT(TableB)
> cWhere = cWhere + 'TableB.' + FIELD(n) + '= TableA.' + FIELD(n)
>ENDFOR
>
>cStatement = 'SELECT B.* FROM TableB B, TableA A WHERE ' + cWhere
>
>&cStatement
>
>Wilson

Error: SQL statement too long.

I'm working with 200+ fields so the list of field names goes way over the 254 limit.

Looks like I'm going to need to do a scan between the tables? Any other ides before I go that route? Anyone?

Renoir