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


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

Re: Joining(?) question

Path csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!novia!newspump.sol.net!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From "Lew" <lew@THRWHITE.remove-dii-this>
Subject Re: Joining(?) question
Message-ID <geccom$dhb$1@aioe.org> (permalink)
X-Comment-To comp.lang.java.databases
Newsgroups comp.lang.java.databases
In-Reply-To <1fe245d6-3222-4bfb-b2b2-bf16bdc98924@64g2000hsu.googlegroups.com>
References <1fe245d6-3222-4bfb-b2b2-bf16bdc98924@64g2000hsu.googlegroups.com>
Content-Type text/plain; charset=IBM437
Content-Transfer-Encoding 8bit
X-Gateway time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines 25
Date Wed, 27 Apr 2011 15:23:05 GMT
NNTP-Posting-Host 96.60.20.240
X-Complaints-To news@tds.net
X-Trace newsreading01.news.tds.net 1303917785 96.60.20.240 (Wed, 27 Apr 2011 10:23:05 CDT)
NNTP-Posting-Date Wed, 27 Apr 2011 10:23:05 CDT
Organization TDS.net
Xref x330-a1.tempe.blueboxinc.net comp.lang.java.databases:326

Show key headers only | View raw


  To: comp.lang.java.databases
mdR wrote:
> SELECT BM.PARENT, BM.ITEM, IM.DESC
> FROM BM
> JOIN IM ON IM.ITEM = BM.ITEM
> WHERE BM.PARENT = 1;

Different RDBMSes vary wrt JOIN syntax.  But RGB's version should have worked, 
too.

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.

-- 
Lew

---
 * 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 | NextPrevious in thread | Next in thread | Find similar


Thread

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

csiph-web