>>

>>SELECT Billing_charges.*, Viscodes.ccode_description;
>> FROM ;
>>     Billing_charges ;
>>    LEFT OUTER JOIN VisCodes ;
>>   ON  Viscodes.ccode_value LIKE ( Billing_charges.crevenue_code+"%" );
>>  AND Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" )
>> WHERE  Billing_charges.cbilling_main_fk = ( ?vp_cBilling_main_fk )
>>

>
>The View designer doesn't take it :(

So define the view by hand. There are a number of valid views and queries you can't write in the VD/QD.

Tamar