Alternatively, you could try something like this :
SET @rownum = 0;
SELECT @rownum := @rownum + 1 AS rownumber_column,
some_real_columnnames
FROM your_table
LIMIT 100
-Original Message-
From: Clyde Lewis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 25, 2006 3:14 PM
To: [EM
Wouldn't some variation on a MERGE table help with this?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 2:45 PM
To: Michael J. Pawlowsky
Cc: [EMAIL PROTECTED]
Subject: Re: How to get around lack of views?
On Mon, Mar 29, 2004 at 03:58:29PM