>>>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 ) >>>>>