I have two tables, generatedblock table, and addresses table
The generatedblock table has a column called expandedblock block.
The addresses table has a column called address.
What I need to do is find if in the generatedblock table there is a value in the addresses table.
I have tried failed code but I am not reposting because my tsql sucks,
How do I check every row in the address table, or visi versa contains a value, and to list the value in a temp table.
x
table generatedblock column expandedblock
-------------
1234
2334
4567
9878
4353
2345
3456
table addresses column address
-------------
1111
2222
3333
4444
5555
6666
1234
i get result return more than 1 row and I want those rows
SELECT *
FROM generatedblock
WHERE ExpandedBlock in (SELECT DISTINCT address FROM addresses)
Advertisement
Answer
You might be looking for INNER JOIN
:
SELECT *
FROM generatedblock A
INNER JOIN address B
ON A.ExpandedBlock = B.address;