I have two tables: Products and Suppliers. SupplierID is a foreign key in products table. I need to make a table that contains country, supplierID, company name
From two columns in my table I want to get a unified count for the values in these columns. As an example, two columns are: Table: reports | type