[SQL]中使用联接
摘要：DECLARE @a table(i int)DECLARE @b table(i int)INSERT INTO @a SELECT 1 UNION ALL SELECT 2INSERT INTO @b SELECT 1 UNION ALL SELECT 3SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i =b.iSELECT a.i,...
阅读全文
posted @ 2005-02-25 14:32