I was attempting to complete this request:
Display all of the supplier information from the suppliers which are from the same country as Norske Meierier.
This is the code that I typed:
WHERE EXIST (SELECT CompanyName FROM Suppliers WHERE CompanyName = 'Norske Meierier' AND Country = 'Norway')
This is the error message that I am getting
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'Norske'.
What mistake am I making and what would be the correct syntax for this code?