Database SQL express 2005 e confronto dati

SELECT n1, n2, n3 from nome_tabella where n1=n11, n2=n21, n3=n31.

USE tempdb;

CREATE TABLE dbo.Ciclo(
n1 int NOT NULL,
n2 int NOT NULL,
n3 int NOT NULL
);

CREATE TABLE dbo.Series(
n1 int NOT NULL,
n2 int NOT NULL,
n3 int NOT NULL
);

INSERT dbo.Ciclo VALUES(1, 5, 10);
INSERT dbo.Ciclo VALUES(3, 6, 12);
INSERT dbo.Ciclo VALUES(4, 8, 15);

INSERT dbo.Series VALUES(1, 2, 3);
INSERT dbo.Series VALUES(5, 6, 7);
INSERT dbo.Series VALUES(6, 8, 9);
INSERT dbo.Series VALUES(1, 5, 10);

SELECT *
FROM dbo.Ciclo
EXCEPT
SELECT *
FROM dbo.Series;

/* Output:

n1          n2          n3
----------- ----------- -----------
3           6           12
4           8           15

(2 row(s) affected)

*/

DROP TABLE dbo.Ciclo, dbo.Series;