user592704
user592704

Reputation: 3704

T-SQL - table variable select

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

Answers (1)

Matt Smucker
Matt Smucker

Reputation: 5234

Change "id =" to "id IN"

WHERE id=(SELECT id FROM @A) 

to

WHERE id IN (SELECT id FROM @A) 

Upvotes: 2

Related Questions