SELECT DISTINCT *
FROM table1 t1
    , table2 t2
WHERE t1.KEY = t2.KEY

SELECT DISTINCT
    *
FROM
    table1 t1
    , table2  t2
WHERE
     t1.key= t2.key

SELECT DISTINCT *
FROM table1 t1
INNER JOIN table2 t2 ON t1.KEY = t2.KEY

SELECT DISTINCT
    *
FROM
    table1 t1
    INNER JOIN table2 t2 ON t1.KEY = t2.KEY

select  1 as a
      , 2 as b

while <условие>
begin
...
  select
    case
    ...
   end
...
end

************** Exception Text **************
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'sysmanagement_shared_server_groups', database 'msdb', schema 'dbo'.
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand, SqlCommand& command)
   --- End of inner exception stack trace ---

cкачать