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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"