Database

SELECT *
FROM   UC
WHERE uc_key IN (SELECT mo_Key
		FROM MO  		 
		WHERE 	(mo_MoKey = @Key1 AND mo_Value = @Value1) 
		OR	(mo_MoKey = @Key2 AND mo_Value = @Value2) 
		GROUP BY mo_Key
		HAVING COUNT(*) > 2);

Select ...
From YourPrimaryTable
InnerJoin YourDetailTable
  on YourPrimaryTable.Column1 = YourDetailTable.Column1
  and YourPrimaryTable.Column2 = YourDetailTable.Column2
  ...

Update DB1.dbo.T1 set DB1.dbo.T1.column='value' where DB1.dbo.T1.colname ='conditionvaue'<br />
Update DB2.dbo.T1 set  DB2.dbo.T1.column='value' where  DB2.dbo.T1.colname ='conditionvaue'

UPDATE T1
SET ...
FROM T1
INNER JOIN T2
ON T1.blah=T2.blah
AND ...

select FirstTable.*,SecondTable.*<br />
from FirstTable,SecondTable<br />
where SecondTable.FirstTableColumn in (FirstTable.FirstColumn)

Select *
Into Table
From
(
TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract into y
) t