Re: SELECT MAX(processor_id) AS p_id FROM * ??? Andere oplossing?

Article View: be.comp.programming

Article #7360

Back to be.comp.programming Previous Next

#7360

From: Toni Van Remortel
Date: Fri, 04 Oct 2002 12:24

19 lines
1868 bytes

Toni Van Remortel wrote:

> Wim Godden wrote:
> 
>> Misschien :
>> SELECT GREATEST(MAX(tabel1.processor_id),MAX(tabel2.processor_id)) AS
>> p_id FROM tabel1, tabel2;
>> 
>> Give it a try and let me know !
> 
> Dat lijkt wel te lukken. Maar ik moet wel alle tabellen zelf invoeren :-(
> Even lmij 30 min brainlass bezighouden met copy-n-paste.

Blijkbaar toch sneller gegaan dan ik dacht. Maar MySQl loopt er op vast :(
Met 2 tabellen ging het vanzelf, maar met alle tabellen loopt ie vast.

-- 
$Toni->Groeten();
$Toni->SetQuote("$ man woman \n No manual entry for woman");

Technical Details

Message-ID: <0Mfn9.145216$8o4.21480@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!news-hub.cableinet.net!blueyonder!btnet-peer!btnet!newsfeed.london1.eu.level3.net!level3eu!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

References:

<HGdn9.144956$8o4.21563@afrodite.telenet-ops.be> <3D9D77FC.46E36323@godden.net> <5vfn9.145187$8o4.21491@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,d62dd09211bd05b1
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-10-04 05:32:04 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!proxad.net!news-hub.cableinet.net!blueyonder!btnet-peer!btnet!newsfeed.london1.eu.level3.net!level3eu!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
From: Toni Van Remortel <ToniVR @ softhome . net>
Subject: Re: SELECT MAX(processor_id) AS p_id FROM * ??? Andere oplossing?
Newsgroups: be.comp.programming
References: <HGdn9.144956$8o4.21563@afrodite.telenet-ops.be> <3D9D77FC.46E36323@godden.net> <5vfn9.145187$8o4.21491@afrodite.telenet-ops.be>
Lines: 19
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <0Mfn9.145216$8o4.21480@afrodite.telenet-ops.be>
Date: Fri, 04 Oct 2002 12:24:28 GMT
NNTP-Posting-Host: 213.118.10.203
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1033734268 213.118.10.203 (Fri, 04 Oct 2002 14:24:28 MET DST)
NNTP-Posting-Date: Fri, 04 Oct 2002 14:24:28 MET DST
Organization: Telenet Internet

Reply to Parent Message