Reputation: 3704
I just wondering how to select values from table B according to table A col values; The idea is quite simple but I have confused a little
code like a
DECLARE @A TABLE
(
id INT NOT NULL,
name VARCHAR(50)
);
INSERT @A SELECT id,name FROM table1 WHERE id>10
DECLARE @B TABLE
(
address VARCHAR(255),
city VARCHAR(128)
);
INSERT @b SELECT address,city FROM table2
WHERE id=(SELECT id FROM @A)
Upvotes: 0
Views: 284
Reputation: 5234
Change "id =" to "id IN"
WHERE id=(SELECT id FROM @A)
to
WHERE id IN (SELECT id FROM @A)
Upvotes: 2