>>>

>>>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 :(
>
>If you use only the queries that View designer takes, you don't have future.

LOL :) Well, I used View Editor by Steve Sawyer and it worked.