Link to home
Start Free TrialLog in
Avatar of lcor
lcor

asked on

SQL Where Statment with Multiple Values

I need to do a select statement for mutliple values within the same column.

select * from car
where car_name= 'value'

I need several data values for value.  That is value is  pontiac, acura, and volvo.

How do you do that in SQL?  Hope I was able to explain this okay -- it's hard to explain.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you can also use AND

Where Car_Name is 'Pontiac' and 'Acura' And 'Volvo' if you want to select all the car's