Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Tagged as

Subquerry return more than one value

, 8 Oct 2012 CPOL
Use In Instead of =i believe your query will look like thisSelect * from tbl1 where col1=(select col1 from tbl2)Use In operator hereSelect * from tbl1 where col1 in (select col1 from tbl2)

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 9-Oct-12 1:01 Available Santhosh Kumar Jayaraman
Updates in content.
1 No 9-Oct-12 1:00 Available Santhosh Kumar Jayaraman

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Santhosh Kumar Jayaraman
Software Developer Radiometer
India India
I have great passion towards Microsoft technologies. I have experience in Microsoft technologies like WPF, WCF, ASPNET, WinForms,Silverlight, VB.NET, C-Sharp, Entity framework,SSRS, LINQ, Extension methods and SQL server. I started with my career in Infosys in the year 2009 and i worked with Trigent, Education First (EF) in the recent years before joining my current company Radiometer.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150327.1 | Last Updated 9 Oct 2012
Article Copyright 2012 by Santhosh Kumar Jayaraman
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid