Hi Naomi,

can't do, I am just trying to make what we have work. Making the select statement into outer joins is set for after our release this year. This is for the release.

The first select is there from what Sergey and others said needed to be done to get memo fields into the resulting cursor or table from the select.

>I think the table names should be in quotes and with aliases. Also why do you need the first part before the UNION if you're using WHERE .F. ?
>
>Finally, can you replace WHERE with INNER JOINs? The select statement would be easy to understand.
>
>>okay, here are the statements again: