Hi!
this time I'm struggling with queries in Qt.
The problem is that I'm doing a program where the data to be received from the DB varies depending on what the user decides he needs.
So I need to somehow make the SELECT-command interactive.
So the thing is that my basic query look sth like this:

SELECT ID FROM Table1 WHERE Name="bla1";

but then it might be so that the query should look sth like

SELECT ID FROM Table1 WHERE Name="bla1" INTERSECT
SELECT ID FROM Table1 WHERE Name="bla2";

or even like

SELECT ID FROM Table1 WHERE Name="bla1" INTERSECT
SELECT ID FROM Table1 WHERE Name="bla2" INTERSECT
SELECT ID FROM Table1 WHERE Name="bla3" ;

etc.

it depends on what the user decides, so he can say I'm interested on the answer depending on the name being bla1, bla2 and bla3 etc.

so is there a way to do this in Qt?
so I know that in query.exec() one must state a query in advance.

I hope I made myself somehow clear?
thanks for any help