Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Join Table

Join Table

From: Ng K C Paul <paulkcng_at_news.netvigator.com>
Date: 1998/09/25
Message-ID: <6ufj5d$557$1@imsp009a.netvigator.com>#1/1 






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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US