Query in a query

[DBM]

In Access when I have ambiguous joins I can elliminate the ambiguity by
creating a query for part then joining it into the first query. Is there a
way to do this programmatically from a query created in C#?

 

[Helmut Woess]

Am Mon, 18 May 2009 23:00:32 -0400 schrieb DBM:

In Access when I have ambiguous joins I can elliminate the ambiguity by
creating a query for part then joining it into the first query. Is there a
way to do this programmatically from a query created in C#?

That is not a problem of C#. It depends which database you use. You send an
SQL-Statement to the database which will (for the same database) always
look the same, no matter if you use C#, Java, Basic or something else.
So you have to study the manual of the database.

bye,
Helmut