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

Article View: be.comp.programming

Article #7361

Back to be.comp.programming Previous Next

#7361

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

23 lines
1912 bytes

Toni Van Remortel wrote:

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

Dan maar multiple queries. Dat doet ie wel.

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

Technical Details

Message-ID: <eRfn9.145225$8o4.21571@afrodite.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!aotearoa.belnet.be!syros.belnet.be!news.belnet.be!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> <0Mfn9.145216$8o4.21480@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:36:04 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!aotearoa.belnet.be!syros.belnet.be!news.belnet.be!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> <0Mfn9.145216$8o4.21480@afrodite.telenet-ops.be>
Lines: 23
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <eRfn9.145225$8o4.21571@afrodite.telenet-ops.be>
Date: Fri, 04 Oct 2002 12:30:02 GMT
NNTP-Posting-Host: 213.118.10.203
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1033734602 213.118.10.203 (Fri, 04 Oct 2002 14:30:02 MET DST)
NNTP-Posting-Date: Fri, 04 Oct 2002 14:30:02 MET DST
Organization: Telenet Internet

Reply to Parent Message