Welcome to the club. I got the same message with a nearly identical view yesterday. The VFP View Designer isn't designed to handle multiple joins. Write out your SQL in a small PRG and test it, then add the CREATE VIEW code to put the SQL into the DBC as a view. You will have to use the PRG to update the view if you wish to change it. Opening it in the view designer will give you the same error.
HTH
Barbara
>Hi to all
>
>I have the following situasion:
>A sales table with a buyer client no. (cnum) and a seller client no. (cnum2). I now want to create a view with
> 1. sales no. (from the sales table)
> 2. the buyer's name (sales.cnum -> client.cnum)
> 3. the sellers name (sales.cnum2 -> client_a.cnum)
>
>My view retruns the correct data. However, if I exist the view and open it again, I get the error, SQL: Column "CNUM2" not found.
>
>Anybody have an idea why I'm getting this?
>
>Thanks in advance
>
>Willie