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

Article View: be.comp.programming

Article #7357

Back to be.comp.programming Previous Next

#7357

From: Toni Van Remortel
Date: Fri, 04 Oct 2002 10:02

10 lines
1450 bytes

Is er een mogelijkheid om met 1 MySQL lijntje, de maximum waarde te bepalen 
van een veld dat in meerdere tabellen voorkomt?
Maw: het veld 'processor_id' staat in +/- de helft van de tabellen, en ik 
wens de grootste waarde ervan te kennen over gans de database.

SELECT MAX(processor_id) AS p_id FROM *;
is helaas niet toegestaan :-(
-- 
$Toni->Groeten();
$Toni->SetQuote("$ man woman \n No manual entry for woman");

Technical Details

Message-ID: <HGdn9.144956$8o4.21563@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!newsfeed.gamma.ru!Gamma.RU!syros.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,d62dd09211bd05b1,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-10-04 03:12:05 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!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: SELECT MAX(processor_id) AS p_id FROM * ??? Andere oplossing?
Newsgroups: be.comp.programming
Lines: 10
User-Agent: KNode/0.7.1
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <HGdn9.144956$8o4.21563@afrodite.telenet-ops.be>
Date: Fri, 04 Oct 2002 10:02:15 GMT
NNTP-Posting-Host: 213.118.10.203
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1033725735 213.118.10.203 (Fri, 04 Oct 2002 12:02:15 MET DST)
NNTP-Posting-Date: Fri, 04 Oct 2002 12:02:15 MET DST
Organization: Telenet Internet