Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #332

Re: Joining(?) question

Show all headers | View raw

  To: comp.lang.java.databases
On Nov 4, 5:35 am, David Kerber <ns_dkerber@ns_wraenviro.com> wrote:
> In article <72ed2328-62ae-491f-be9f-b6faad045e13
> @q26g2000prq.googlegroups.com>, first...@ix.netcom.com says...
> > On Nov 1, 5:17 pm, Lew <no...@lewscanon.com> wrote:
> > > Lee Fesperman wrote:
> > > > On Oct 30, 5:27 am, Lew <no...> > > >> Some allow
>
> > > >> SELECT BM.PARENT, BM.ITEM, IM.DESC
> > > >>   FROM BM JOIN IM
> > > >>   WHERE BM.PARENT = 1;
>
> > > >> if there's a FK on the ITEM column to the other table.
>
> > FK joining is non-standard and begs the question: Which FK for which
> > table is used?
>
> That syntax is only allowed if there is exactly one FK/PK combination
> that would satisfy the join.  Otherwise you get an error that says
> something to the effect of "there is more than one way to join table1 to
> table2"

That answers my question! Thanks for the info, on Sybase.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: Joining(?) question "Lee Fesperman" <lee.fesperman@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000

csiph-web