Yes Union and More. In one of my DOS app I have a very complicated govt. report which bring in details from Inventory, Finance, and Excise Duty, for the current period and progressive. What I have done is first create small queries and then using these small queries Unioned them into a query with selective fields, this is for part 4. Similarly for Parts 5, 6, 7 & 8.
<i><font color="#663300">Hi Bhavbhuti,
<i><font color="#663300">How about multiple SQL cursors based on different sets of data which don't readily join, joined into one SQL View, is it possible?</font></i>
Well, you either create one cursor or you don't. I am not sure what you mean. Are you talking about UNION?
</font></i>
Regards
Bhavbhuti
©2002 Bhavbhuti Nathwani |
