Re: Join Table

From: Craig Kickel <ckickel_at_micron.net>
Date: 1998/09/25
Message-ID: <POMO1.1$_36.115165@skin01.micron.net>#1/1

Is this what you mean?

    SELECT *
    FROM tab1
    WHERE tab1_key = (SELECT MAX(tab2_key) FROM tab2)

--Craig

Ng K C Paul wrote in message <6ufj5d$557$1_at_imsp009a.netvigator.com>...
>Is it possible to join two tables based on certain criteria? For example,
>
>tab1_key tab2_key
>-------- --------
>10 9
>20 18
>30 27
>40 39
>50 50
>
>Table2 with key smaller or equal to table1.
>
>Can I select the maximun of key of table2 and join with table1?
Received on Fri Sep 25 1998 - 00:00:00 CDT