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