Why don't you use
Select a, b, c From table1
UNION ALL
Select a, x ,y From table2
(Assuming the field types are identical. Otherwise it wouldn't make
sense any way)
Aby
-----Original Message-----
From: Rodriguez, Sergio [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 02, 1999 4:09 PM
To: [EMAIL PROTECTED]
Subject: [ND] Stored Procedures
Hi all,
I'm using a store procedure on SQL Server 6.5 and I'm having the
following
problem.
The store procedure is something like this.
// Select 1
Select a, b, c From table1
// Select 2
Select a, x ,y From table2
GO
Know, from NetDynamics when I create the DataObject and execute it I
just
got the results from the first select (Select 1)
My question is, Is there any way to get the results from the 2 selects.
Thanks in advance.
________________________________________________________________________
_
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to:
http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
