SQL Query Help

[jason_kelly]

Hi There,

I need your help on an SQL Query.

How would I go about selecting 2 conditions from the table below and have a recordset like the following?:

Name FileNumber Status
John Doe 1534905834 Active
Lizzy McGuide 4923049233 Active
John Doe 2349234230 Closed
Jane Smith 2315432453 Closed
John Doe 2034534532 Active
John Doe 9089089092 Active

I would like to create an SQL query that would pull all the records for John Doe that are in the 'Active' status,
yielding the following records:

Name FileNumber Status
John Doe 1534905834 Active
John Doe 2034534532 Active
John Doe 9089089092 Active

Any help with this is greatly appreciated.

Cheers and have a great day!

Jay

[orange]

SELECT [Name],Filenumber, Status
FROM "yourTable"
Where
[Name] = "John Doe" AND
Status = "Active"