Table joins

From: JagMan <jagman98_at_home.com>
Date: 2000/06/05
Message-ID: <393C3D66.760B01CE@home.com>#1/1

The Select command does not generate any output.

Follwing example:

TableA

    Model        Code
    ACME        1001
    RR             1100

>Index Code;

TableB

    TimeStamp                   Code         VALUE
    Jan/4/2000 23:30        1100                10
    Jan/5/2000 23:50        1100                11
    Jan/5/2000 21:00        1001                10
    Jan/5/2000 23:50        1001                15

>Index TimeStamp, and Code

Output:

Time Range [ Jan/4/2000 18:00 ] - [ Jan/5/2000 03:00 ]

    Model        Total
    ACNE            25
    RR                21

============================

select m.model, sum(s.value) VAL from TableA m, TableB s where m.code = s.code and s.TimeStampe between to_date( 'Jan/4/2000 18:00', 'Mon/DD/YYYY HH24:MI') and to_date( 'Jan/5/2000 3:00', 'Mon/DD/YYYY HH24:MI') Group by m.model order by VAL desc;

The command seems to hang at prompt.

Thanks in Advance! Received on Mon Jun 05 2000 - 00:00:00 CDT