Article View: dk.edb.database
Article #15003Re: MySQL og subselect i LEFT JOIN
From: Jesper Stocholm
Date: Sun, 29 Jul 2001 16:08
Date: Sun, 29 Jul 2001 16:08
25 lines
2044 bytes
2044 bytes
Mads Lie Jensen <mads@gartneriet.dk> wrote in news:e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com: > 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. > Det var da lidt underligt ... er det et bevidst fravalg ... eller er man blot ikke kommet dertil endnu ? -- ... der s�ger lejlighed fremleje/leje i K�benhavnsomr�det. Max. kr. 3500 om m�neden alt inklusive. - Jesper Stocholm - http://stocholm.dk
Technical Details
Message-ID:
<Xns90EDB883CF6D7spamstocholmdk@192.38.208.81>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!nntp.cs.ubc.ca!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!130.226.1.33!news.net.uni-c.dk!newsfeed.k-net.dk!not-for-mailReferences:
<Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81> <e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com>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 09:15:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!nntp.cs.ubc.ca!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!130.226.1.33!news.net.uni-c.dk!newsfeed.k-net.dk!not-for-mail
From: Jesper Stocholm <spam@stocholm.dk>
Newsgroups: dk.edb.database
Subject: Re: MySQL og subselect i LEFT JOIN
Date: Sun, 29 Jul 2001 16:08:34 +0000 (UTC)
Organization: stocholm.dk
Lines: 25
Message-ID: <Xns90EDB883CF6D7spamstocholmdk@192.38.208.81>
References: <Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81> <e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com>
NNTP-Posting-Host: dummy107.pop.k-net.dk
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: eising.k-net.dk 996422914 1400 192.38.220.176 (29 Jul 2001 16:08:34 GMT)
X-Complaints-To: drift@k-net.dk
NNTP-Posting-Date: Sun, 29 Jul 2001 16:08:34 +0000 (UTC)
User-Agent: Xnews/4.06.22
X-Face: 9L7#H|IRDe",jxWJD,mQgO4LU9S_kE}KT;Au}.w&w{d=@h_V)j~J9PPW"^yQ:XEP$py'*g.PfhZDu6[.S9~STQIlb#?P[/{23hVj{UEziR!lz@#i(yQzzO(0r(A~_3vEaPE]*E62Lot,,3jV/E+[a%$Tp9aZ.RQMM[jT=E]yLs*R