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 !!

JOIN !!

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Wed, 18 Aug 1999 22:54:31 GMT
Message-ID: <7pfdj2$nfa$1@nnrp1.deja.com> 





Hi



This is a question in JOINs.



There are two tables, one with REGION and STATE, and another with
COUNTY. Each county in a state will start with the name of that state,
like NY.XX,NJ.YY etc. (!! XX and YY are name of the counties)



The goal is to join these two tables to list
REGION, STATE, and COUNTY.



I tried some queries with LIKE. But no rows are selected.
If there is a solution to this other than using CURSORs, i would be
interested in it.


Thanks


-


Nandakumar




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Wed Aug 18 1999 - 17:54:31 CDT












Original text of this message













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