Re: Try to figure out how to write a query which will show ONLYthehighest revision number for a given Item number

["Steve Landess" <sjl_abc@xxxxxxxxxxx>]

"Charles Wilt"  wrote:

> The way you get around this kind of limitation is to create a view with 
> the
> SELECT that you need.
> Then in the external tool, Showcase in this instance, all you need is
> SELECT * FROM MYVIEW


Thanks, Charles-

That's what I ended up doing.  I'll post my solution later.

-sjl