view with a rownum
From: Ilariu Raducan <lale_at_fotonation.com>
Date: Thu, 29 May 2003 18:42:00 +0100
Message-ID: <JDrBa.15762$pK2.21592_at_news.indigo.ie>
Hi All,
Lale Received on Thu May 29 2003 - 19:42:00 CEST
Date: Thu, 29 May 2003 18:42:00 +0100
Message-ID: <JDrBa.15762$pK2.21592_at_news.indigo.ie>
Hi All,
I'm trying to create a view from two tables that will have a column
rownumber autoincrement.
Don't laugh, all that in Microsoft Jet Engine.
CREATE VIEW view3 AS
SELECT p.file_name,r.num_total,r.num_detected,r.num_false,rownumber
FROM pictures p, results r WHERE r.picture_id=p.picture_id AND
r.version_id=2;
Is it possible to do that?
Thank you,
Lale Received on Thu May 29 2003 - 19:42:00 CEST