RgueWave and Join two Table

From: Josef Böhm <boehm_at_fct.de>
Date: Thu, 18 Oct 2001 11:58:38 +0200
Message-ID: <3BCEA7CE.54EB7FDA_at_fct.de>

[Quoted] [Quoted] How can I make the following statement with the RougueWave BDTool++ ?

SELECT *
FROM TableObj, (select objnr as OBJ_NR, MAX(version) as MAX_NR from TableObj Groupby objnr)
WHERE objnr = OBJ_NR and version = MAX_NR

Do someone has an other idea to make this statement ?

Thanks Josef Boehm Received on Thu Oct 18 2001 - 11:58:38 CEST