Jan Theodore,
This query don't running too
SELECT *
FROM tbl_hlt_phonecall_historicaldata
WHERE int_key =
(
SELECT max(int_key)
FROM tbl_hlt_phonecall_historicaldata
GROUP by int_phonecall_key
)
tks,
Daniel
----- Original Message -----
From: "Jan Theodore Galkowski" <jtgalkowski@stripped>
To: "Daniel Bronzeri Barbosa" <daniel@stripped>
Sent: Tuesday, December 14, 2004 2:25 PM
Subject: [BRMA-ALTO-RISCO] Re: Help in Subquerys...
Well, Daniel, for one thing the SQL syntax isn't right. Try:
... WHERE int_key = (select max(int_key) from ...
-jtg
On Tue, 14 Dec 2004 15:24:55 -0300, "Daniel Bronzeri Barbosa"
<daniel@stripped> said:
> People,
>
> How can I run this query in MySQL 4.0???
>
> SELECT *
> FROM `tbl_hlt_phonecall_historicaldata`
> WHERE int_key in
> (
> select max(int_key)
> from tbl_hlt_phonecall_historicaldata
> group by int_phonecall_key
> )
[snip]
--
Jan Theodore Galkowski (o°)
jtgalkowski@stripped
http://www.smalltalkidiom.net
