>>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 ) >>>
WHERE Billing_charges.cbilling_main_fk = ( ?vp_cBilling_main_fk ) AND Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" ) OR Viscodes.ccategory_description IS NULL * IS WHERE ( Billing_charges.cbilling_main_fk = ( ?vp_cBilling_main_fk ) AND Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" ) ) OR Viscodes.ccategory_description IS NULL * CORRECT is WHERE Billing_charges.cbilling_main_fk = ( ?vp_cBilling_main_fk ) AND (Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" ) OR Viscodes.ccategory_description IS NULL)But even if it works, this last form is not equivalent to mine;