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

Article View: be.comp.programming

Article #7358

Back to be.comp.programming Previous Next

#7358

From: Wim Godden
Date: Fri, 04 Oct 2002 11:12

28 lines
1916 bytes

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 !

--
------
Colocation/housing kosten te hoog --> http://www.housingcenter.be
--
Adverteren.be - 100% Nederlandstalig adverteren op kwalitatief hoogstaande
sites !




Toni Van Remortel wrote:

> 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: <3D9D77FC.46E36323@godden.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!syros.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mail

References: <HGdn9.144956$8o4.21563@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 04:22:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!syros.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mail
Message-ID: <3D9D77FC.46E36323@godden.net>
From: Wim Godden <wim@godden.net>
Organization: FirstLink Networks
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: be.comp.programming
Subject: Re: SELECT MAX(processor_id) AS p_id FROM * ??? Andere oplossing?
References: <HGdn9.144956$8o4.21563@afrodite.telenet-ops.be>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
Date: Fri, 04 Oct 2002 11:12:54 GMT
NNTP-Posting-Host: 213.224.241.115
X-Complaints-To: abuse@telenet.be
X-Trace: hestia.telenet-ops.be 1033729974 213.224.241.115 (Fri, 04 Oct 2002 13:12:54 CEST)
NNTP-Posting-Date: Fri, 04 Oct 2002 13:12:54 CEST

Reply to Parent Message