Hi,

I'm looking to refine ways i've written my current application to make it more efficient.
Is it possible to write a query who's WHERE parameter is the result of another query without using a procedure/function?
Use the classic Product details table as an example

My query currently looks like
SELECT productID, productDescription, productPrice from tblProducts where productPrice >= (Select productPrice from tblProducts where productID = 7)

This is probably a bad example but the underlined part of that query show what i'm trying to achieve.
Is it possible to use another query as part of the WHERE clause?
At the moment i'm getting syntax errors.

Many Thanks

yes it is possible, we do this all the time

So is the syntax I used above correct?

nvm - according to this article I wouldn't be able to alter the table in my query anyway (I was hoping to use this to write an UPDATE query) because i'd be using a subquery that looked up the same table I was trying to update.

yep, it is