Select * from table where ID list is on another table

Question

use temp1 select * from [TZraw].[dbo].[A1] where [TZraw].[dbo].[A1].[ID] in [select F1 from info1]

I am trying to select all the records from TZraw table A1 that match every record in temp1 table F1

Is F1 the id ? All you have to do is return the ID from info1. select * from [TZraw].[dbo].[A1] where [TZraw].[dbo].[A1].[ID] in (select F1 as id from info1) — Rafal
– Rafal, Commented Feb 22, 2011 at 13:09

Pablo Santa Cruz · Accepted Answer · 2011-02-22 13:10:00Z

Use parenthesis:

select * from [TZraw].[dbo].[A1] where [TZraw].[dbo].[A1].[ID] in (select F1 from info1)

Instead of square brackets on the subselect.

eumiro · Accepted Answer · 2011-02-22 13:09:31Z

Try round brackets for the subquery:

use temp1 select * from [TZraw].[dbo].[A1] where [TZraw].[dbo].[A1].[ID] in (select F1 from info1)

Albin Sunnanbo · Accepted Answer · 2011-02-22 13:09:52Z

You need parenthesis for the IN clause

select * from [TZraw].[dbo].[A1] where [TZraw].[dbo].[A1].[ID] in (select F1 from info1)

serhat_pehlivanoglu · Accepted Answer · 2011-02-22 13:11:23Z

1

try this in your query

... in (select F1 from info1)

answered Feb 22, 2011 at 13:11

9828 silver badges14 bronze badges

Comments

Oded · Accepted Answer · 2011-02-22 13:12:06Z

Your SQL syntax is incorrect - the subquery should be in parens - (), not square braces [].

Use a join instead of a subquery - SQL is better optimized for it:

SELECT first.* FROM [TZraw].[dbo].[A1] AS first INNER JOIN info1 AS second ON first.ID = second.F1

Csabi · Accepted Answer · 2011-02-22 13:11:24Z

Try to create a temporary table

Select * From Tzrav ti Where .... ti...<>t...

REATE TEMPORARY TABLE SalesSummary ( Select* From Temp1 t Where .... )