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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Join syntax question

Re: Join syntax question

From: Bagieta <user_at_example.net>
Date: Wed, 15 Jun 2005 15:06:06 +0200
Message-ID: <d8p93o$mbl$1@news.onet.pl> 





select b.*,


(select name from authors a where a.bookid = b.id and rownum = 1)
from books b


--
Kind regards
Bagieta


------------------------------------

dbDeveloper - Oracle database editor
www.dbdeveloper.prominentus.com


------------------------------------



Received on Wed Jun 15 2005 - 08:06:06 CDT












Original text of this message













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