Re: Select Top statement

[Alexander Riemer]

Kevin,

I think he meant something like:

select *
  from TableA A, (select top 3 ColumnA, ColumnB from TableB) B
  where A.ColumnA=B.ColumnA

Alex

"kevin furze" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]
> select top 3 Description, Name
>      from SQLUser.Tools
>      where Active=1
>      order by Description
>