SELECT C.custid, E.empid
FROM Sales.Customers AS C
CROSS JOIN HR.Employees AS E
ORDER BY E.empid

IF OBJECT_ID('dbo.Digits','U')
IS NOT NULL DROP TABLE dbo.Digits;
CREATE TABLE dbo.Digits
(
 digit INT NOT NULL
);

USE TSQL2012
GO
INSERT INTO dbo.Digits
  ( digit )
VALUES ( 0 ), ( 1 ), ( 2 ), ( 3 ), ( 4 ), ( 5 ), ( 6 ), ( 7 ), ( 8 ), ( 9 )

USE TSQL2012
GO
CREATE TABLE Nums
(
 n INT NOT NULL PRIMARY KEY
);

USE TSQL2012
GO
INSERT INTO dbo.Nums(n)
SELECT D6.digit * 100000 + D5.digit * 10000 + D4.digit * 1000 + D3.digit * 100 + D2.digit * 10 + D1.digit + 1 AS n
FROM dbo.Digits AS D1
 CROSS JOIN dbo.Digits AS D2
 CROSS JOIN dbo.Digits AS D3
 CROSS JOIN dbo.Digits AS D4
 CROSS JOIN dbo.Digits AS D5
 CROSS JOIN dbo.Digits AS D6
ORDER BY n

SELECT *
FROM table1 AS t1
INNER JOIN table2 AS t2 ON t1.Id = t2.Id

USE TSQL2012
GO
CREATE TABLE FirstTable (Col1 INT)
CREATE TABLE SecondTable (Col1 INT)
CREATE TABLE ThirdTable (Col1 INT)
GO
INSERT INTO FirstTable (Col1)
VALUES (1), (2), (3), (NULL)
GO
INSERT INTO SecondTable (Col1)
VALUES (1), (2), (3), (NULL)
GO
INSERT INTO ThirdTable (Col1)
VALUES (2), (2), (2), (2), (2), (NULL)
GO

SELECT f.Col1 fCol1
FROM FirstTable f
 INNER JOIN SecondTable s ON s.Col1 = f.col1
GO

USE TSQL2012
GO
SELECT f.Col1 fCol1
FROM FirstTable f
INNER JOIN SecondTable s ON s.Col1 <> f.col1
GO

USE TSQL2012
GO
SELECT f.Col1 fCol1
FROM FirstTable AS f
 CROSS JOIN SecondTable AS s
where s.Col1 <> f.col1
GO

USE TSQL2012
GO
SELECT f.Col1 fCol1
FROM FirstTable f
INNER JOIN ThirdTable s ON s.Col1 = f.col1
GO

USE TSQL2012
GO
SELECT *
FROM Sales.Orders AS SO
 INNER JOIN Sales.OrderDetails AS SOD ON SOD.orderid = SO.orderid

USE TSQL2012
GO
SELECT *
FROM Sales.Orders AS SO, Sales.OrderDetails AS SOD
WHERE SOD.orderid = SO.orderid

USE TSQL2012
GO
SELECT COUNT(*) AS '利用等值條件查詢總數(shù)據(jù)行' 
FROM Sales.Orders AS SO, Sales.OrderDetails AS SOD
WHERE SOD.orderid = SO.orderid

SELECT COUNT(*) AS '利用等值條件查詢總數(shù)據(jù)行' 
FROM Sales.Orders AS SO, Sales.OrderDetails AS SOD

USE TSQL2012
GO
SELECT *
FROM Sales.Orders AS SO
 INNER JOIN Sales.OrderDetails AS SOD;