Monday, May 09, 2005

Query Design creating where clauses

Doing a typical select statement select * from jobs where vulnCount = 5 doesn't seem to be possible with OpenOffice. To construct a where clause using the Query Design you need to make use of "(" ")" to encapsulate the where condition.

You're query would look like:
SELECT Field from DSN.dbo.Table Table WHERE (field='condition')

0 Comments:

Post a Comment

<< Home