Normally, the choice of the syntax for a self-join is up to you. The query below uses the keyword CROSS JOIN. For training purposes, adjust the query to not use the keywords CROSS JOIN or INNER JOIN! The result should remain unchanged:

HINT

Just leave out the keyword CROSS JOIN and replace it with a comma ,!

Query to Be Adjusted:

SELECT DISTINCT c1.company_name, c1.country FROM northwind.customers AS c1 CROSS JOIN northwind.customers AS c2 WHERE c1.country = c2.country AND c1.company_name != c2.company_name ORDER BY c1.country, c1.company_name;