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

Article View: be.comp.programming

Article #7359

Back to be.comp.programming Previous Next

#7359

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

14 lines
1544 bytes

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.

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

Technical Details

Message-ID: <5vfn9.145187$8o4.21491@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!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>

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:16:05 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!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>
Lines: 14
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <5vfn9.145187$8o4.21491@afrodite.telenet-ops.be>
Date: Fri, 04 Oct 2002 12:06:25 GMT
NNTP-Posting-Host: 213.118.10.203
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1033733185 213.118.10.203 (Fri, 04 Oct 2002 14:06:25 MET DST)
NNTP-Posting-Date: Fri, 04 Oct 2002 14:06:25 MET DST
Organization: Telenet Internet

Reply to Parent Message