SELECT Command - For beginner.
- From: "Ben" <Administrator@xxxxxxxxx>
- Date: Wed, 7 Sep 2005 15:40:30 +0300
Hi, I am having a problem with a SELECT Command.
I am wanting to search unique queries from TableA where Field1 = "specific
Criteria" and Field2 = "Another Specific Criteria.
The string that I have is as follows:
SELECT DISTINCT * FROM Table WHERE fld1 = 'opt1' AND WHERE fld2 = 'opt2';
Any help is appreciated. As you see I am still very new to SQL queries
.
- Follow-Ups:
- RE: SELECT Command - For beginner.
- From: Jose G. de Jesus Jr MCP, MCDBA
- RE: SELECT Command - For beginner.
- Prev by Date: Re: Shrink .LDF File
- Next by Date: RE: SELECT Command - For beginner.
- Previous by thread: Shrink .LDF File
- Next by thread: RE: SELECT Command - For beginner.
- Index(es):
Loading