Unanswered: where clause that uses result of another query?
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.
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.