As a non-expert SQL dabbler, I frequently make an SQL query in several steps, asking a simple query, then a following one which includes some of the data from the previous query. I am faced with a problem in some server code I am developing, which must generate SQL queries. My question is, if it is known that the overall request can be satisfied by an iterative series of SQL queries on a given database, as described above, is it ALWAYS guaranteed that the same problem can be solved with a single more comples SQL query?
A theoretical question
- Thread starter edgecombe
- Start date