From QueryDef to plain SQL text

  • Thread starter Thread starter Edwin Knoppert
  • Start date Start date
E

Edwin Knoppert

I have a few queries in my MDB, some of them are using them as INNER JOINs.
(A SELECT in a SELECT but then using querydefs)

I would like to combine these SQL statements into one but they become highly
complex for me.
I rather would like to embed the SQL text into my application than keeping
them in the DB.

Is there an easy way or should i maintain the querydefs?
 
Edwin,

Access writes the SQL for the querydef. You can just use Access's SQL View
of the query to see the generated SQL.

Kerry Moorman
 
I meant a combination of these two queries.

Query2 contains a select which is based on another query.
So i prepared 2 querydefs.
q2 uses q1, how to convert that statement to single SQL text?
:)
 
I would write an example then.
Imagne a group by querydef using some other kind of SELECT.

I think i'll write me an example tomorrow ok?
 
Back
Top