[V4WS 1.11] Creating a cursor from two tables?

[Ruslan Zasukhin]

On 11/21/06 1:17 PM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

Hi Steven,

> Ruslan,
> 
> I have two tables X and Y:
> 
> table X
> timestamp    price
> 654               23.3
> 544               45.2
> 675               65.4
> 999              55.5
> 
> 
> table Y
> timestamp     price
> 322               23.2
> 699                44.4
> 909               31.1
> 888              34.3
> 
> I want to interleave the records from the two tables
> in order of decreasing timestamp to create a cursor
> that looks like:
> 
> timestamp       price
> 999              55.5
> 909               31.1
> 888              34.3
> 699                44.4
> 675               65.4
> 654               23.3
> 544               45.2
> 322               23.2
> 
> Is there a way to do this in Valentina?

Valentina 2 can do this, with help of UNION.


v1 not in single query.
Only way you cerate new table.
Then use 
    INSERT INTO ... SELECT .. from T1
    INSERT INTO ... SELECT .. from T2

To copy there records, and ORDER BY then this new table.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]