Article View: dk.edb.database
Article #15002Re: MySQL og subselect i LEFT JOIN
From: Mads Lie Jensen
Date: Sun, 29 Jul 2001 15:49
Date: Sun, 29 Jul 2001 15:49
18 lines
1557 bytes
1557 bytes
On Sun, 29 Jul 2001 14:52:40 +0000 (UTC), Jesper Stocholm <spam@stocholm.dk> wrote: >... der ikke virker. > >Men hvis jeg skifter min subselect i min LEFT JOIN ud med blot et tabel-navn >(uden parenteserne), s� virker det som det skal ? > >Hvor ligger fejlen ? Jeg skal lige sige, at ovent�ende query fungerer >up�klageligt p� MS SQL Svr. 2k mySQL underst�tter ikke subselects - derfor. -- Mads Lie Jensen - mads@gartneriet.dk - ICQ #25478403 http://www.gartneriet.dk Directory Opus - nu ogs� til windows - http://www.gpsoft.com.au
Technical Details
Message-ID:
<e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!news.cybercity.dk!not-for-mailReferences:
<Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,83516511d101edf2 X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-29 08:51:14 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!news.cybercity.dk!not-for-mail From: Mads Lie Jensen <mads@gartneriet.dk> Newsgroups: dk.edb.database Subject: Re: MySQL og subselect i LEFT JOIN Date: Sun, 29 Jul 2001 17:49:40 +0200 Organization: Gartneriet Lines: 18 Message-ID: <e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com> References: <Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81> NNTP-Posting-Host: port32.cvx1-hj.ppp.cybercity.dk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.cybercity.dk 996421860 25197 217.157.69.33 (29 Jul 2001 15:51:00 GMT) X-Complaints-To: abuse@cybercity.dk NNTP-Posting-Date: Sun, 29 Jul 2001 15:51:00 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548