Thanks Naomi, but I got it resolved last night with Kevin and Borislav's help :o)



>>Hey, thanks for looking at it. I'm sure those are exactly spot on. However, what I cannot figure out is why the very end of the statement is throwing the error where the ON portion is. Both tables have that field and the field is identical. When I miss something, it is usually something very obvious, so I thought if I posted it, I may actually see it. However, not tonight obviously!
>>
>>
>>
>Hi Tracy,
>
>I guess you worked too hard yesterday.
>
>Basically, here is how your select should look like:
>

>select * from tbl1 tb1 inner join (select ... from tbl2 where) TB2 on ;
>tb1.ID = tb2.ID

>
>And if you compare it with what you currently have you'll see the problem right away.
>
>Perhaps there are other problems there as well, but this was something I noticed from the quick glance.
>
>You can use from tbl1 as tb1 or you can omit AS. In VFP 'AS' is not required.