April 7, 2011

Syntax to join two Select query results

Syntax to join two query in SQL Server

SELECT A.F1,B.F2 FROM
(SELECT F1 FROM T1) AS A,
(SELECT F2 FROM T2) AS B
WHERE
A.F1 = B.F2

No comments:

Post a Comment