How to make a union querie? 1

[PLV]

I am trying to do a union query between 2 tables.

I used to make my querie with the GetDefaultSQL and m_srtFilter of the CRecordset class.

I cannot figure how to make an sql query like this:
SELECT ** FROM A WHERE X=X UNION SELECT *** FROM B WHERE Y=Y

Thx

 

[Cagliostro]

learn SQL John Fill

ivfmd@mail.md

 

[PLV]

The trouble is not really the sql thing is how to write it in C++. The SQL query is exactly the the query I wrote before.

I just don't know how to write this un C++... do you JohnFill?!?!?

If you still don't understand what I don't understand it's: if I try to put this query my m_strFilter would look like "x=x union select *** from B where........" and this looks a bit dumb to me.

Or if you could just explain me how do I use the CDatabase object or the CQueryDef object to make a "UNION" query?

Thx for your time

 

[Cagliostro]

CQueryDef x;
...
x.Open("select... from .. union ....." John Fill

ivfmd@mail.md