FYI: Inner is superfluous and not needed. Same as Outer.
BOb
>
>Do you mean like this?
>
>> select a.inv_no, b.account_no, b.location, c.acc_name, d.part_desc ;
> from order_file a inner join work_history b, work_history b inner ;
> join customer_billing c, order_file a inner join order_items d;
> on a.inv_no = b.inv_no
> into cursor sql_data
>
>>>You need to explicit Join all the tables, A with B, B with C, C with D, or whatever relation you have. >
>I mean like this:
>
>
> SELECT a.inv_no, b.account_no, b.location, c.acc_name, d.part_desc ;
> FROM order_file a INNER JOIN work_history b ON a.inv_no=b.inv_no ;
> INNER JOIN customer_billing C ON b.<InnerField> = c.<RelatedField> .... and the next.
>
>
>
>See in your VFP help the topic "Join Conditions for Tables, Queries, and Views"
