Re: MySQL og subselect i LEFT JOIN

Article View: dk.edb.database

Article #15004

#15004

From: Jonas Delfs
Date: Sun, 29 Jul 2001 16:40

23 lines
2000 bytes

"Jesper Stocholm" <spam@stocholm.dk> skrev i en meddelelse
news:Xns90EDB883CF6D7spamstocholmdk@192.38.208.81...

> >>... 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 ?

Det sidste. Det st�r p� deres "Things to be done in very near future"-liste.

--
Mvh./Best Regards | Jonas Delfs, http://delfs.dk

"Developers are being asked to do more with less, do it faster, and make it
fit with the existing systems and databases." - IDC

Technical Details

Message-ID: <9k1e5m$9eu$1@sunsite.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail

References:

<Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81> <e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com> <Xns90EDB883CF6D7spamstocholmdk@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 09:38:16 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail
From: "Jonas Delfs" <jonas@nospam.delfs.dk>
Newsgroups: dk.edb.database
Subject: Re: MySQL og subselect i LEFT JOIN
Date: Sun, 29 Jul 2001 18:40:17 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 25
Sender: jonas@131.165.143.165
Message-ID: <9k1e5m$9eu$1@sunsite.dk>
References: <Xns90EDABA5F1BB9spamstocholmdk@192.38.208.81> <e3c8mtoq7t15ff32tsupoejno7eb2ere4r@4ax.com> <Xns90EDB883CF6D7spamstocholmdk@192.38.208.81>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 996424694 9694 131.165.143.165 (29 Jul 2001 16:38:14 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Sun, 29 Jul 2001 16:38:14 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-Authenticated: jonas@delfs.dk

Reply to Parent Message