asked
List of multiple records referring another table
I want to get a list of all the records for below query, at the moment there are hundreds of record exist for this query but as this query can only return one record (even I will have to add "Top 1"), I cannot use it. Can someone help me to change this query so that I can get all the records from Table T1 for the condition, below is my query: select * from table T1 where COLUMN C1 = (select COLUMN C2 from Table T2 where COLUMN C3 = Value)
As posted there is no chance anybody can help you. There simple isn't enough information for anything more than a guess. It seems like you could change this to a join but it is impossible to tell for sure. This would be a great place to start for getting an answer.
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
Or you could use 'in' clause to get all the records:- select * from table T1 where COLUMN C1 in (select COLUMN C2 from Table T2 where COLUMN C3 = Value)
Assuming a variable @value is of the right data type and holds the value you want for your criteria, I believe the following should work for you: SELECT t1.* FROM table1 t1 INNER JOIN table2 t2 ON t2.column2 = t1.column1 WHERE t2.column3 = @value ;
20 People are following this question.
