Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: christ
  Where is christ?
 jakarta
 Indonesia
 christ
 Tags
Subject: RE: break union query ?
Thread ID: 112214 Message ID: 112311 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Tuesday, November 07, 2006 9:05:58 AM         
   


> > select fld1,fld2,.t. as fld from table1 union all select fld1,fld2,.f. as fld from table2
> >
>
> Thanks Mr.Tushar, I mean , my query like your query but now i want to break it into 2 different query or using SubQuery
>
>
>
>
> thank you
>
>
> Christ

select that into cursor. then with the cursor you can
set filter to fld / set filter to not fld
or
you should be able to give
select * from dbf('yourcursor') where fld

Regards
Tushar

ENTIRE THREAD

break union query ? Posted by christ @ 11/6/2006 9:54:35 AM
RE: break union query ? Posted by tushar @ 11/6/2006 1:28:46 PM
RE: break union query ? Posted by christ @ 11/7/2006 2:07:49 AM
RE: break union query ? Posted by tushar @ 11/7/2006 9:05:58 AM