Is there a way to pull multiple records using where clause..
EXAMPLE::
SELECT * FROM name WHERE age=12, age=35, age =15
Or do I have to use seperate select for each type or record i wanna pulll...
you can use an or statment.
select * from name where age = 12 or age = 35, or age = 15
don't need the commoas
doubt.. I knew that.. LOL Been a long evening.. LOL THanx
An alternate way:
SELECT * FROM name WHERE age IN ('12', '35', '15');
Jon