Thanks Gail, it all makes sense but I couldn't seem to create the right query myself.

Cheers!

Anyone? I'm really stuck on this so any help or pointers would be greatly appreciated!

I've now found that the highest Versions.Ref does not necessarily equal the most recent row. As such I'm going to need to change the sub query such that it uses...

Thanks Garadin, works a treat 🙂

Thats a pretty cool query. I like it. Unfortunately, I've just discovered the box I need to run this query on is a SQL Server 2000 machine. WITH and ROW_NUMBER()...

Thanks Chris, that looks good. I didn't know you could join on a query like that 😛

Do you think your method above is more efficient than say,

SELECT p.Publisher,

...