I am trying to perform a select on the below code, but I am not performing the select correctly. Could you let me know what the query should look like?
Company --> Company.Code
Company_Rules --> Company_Rules.Company
Sample Input Data
Company Rule Code
In essence I want all of the company data that that with the matching company_rules data. But the resulting output does not return multiple rows of company_rules. The data that does not find a matching company_rules field is also return.