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