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: 112230 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, November 06, 2006 1:28:46 PM         
   


> dear all,
>
> How 2 change query that using UNION clause with SubQuery or break this UNION query to 2 different query
>
>
> than\ks

Create an additional column

select fld1,fld2,.t. as fld from table1 union all select fld1,fld2,.f. as fld from table2

the fld will tell you where the row came from

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