We help IT Professionals succeed at work.
Get Started

sql 2008  sub query

679 Views
Last Modified: 2012-05-09
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:

SELECT *
FROM Suppliers
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?
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE