Home > IT Answers > SQL Server > How to display values in one table by referring and checking values in another table?
Sqldb
5 pts.
 How to display values in one table by referring and checking values in another table?
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables
how to display values in one table by refering and checking values in another table

Software/Hardware used:
sql server
ASKED: July 28, 2010  8:08 AM
UPDATED: July 28, 2010  5:58 PM
RELATED QUESTIONS
Answer Wiki:
<pre>SELECT a.column_x, a.column_y FROM table1 a JOIN table2 b ON a.column_z = b.column_z WHERE b.column_w = <something> AND ...</pre> If you need a more specific answer, please provide more details.
Last Wiki Answer Submitted:  July 28, 2010  4:01 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hey Sqldb, Did Carlos’ answer help? If not, provide us with some more details. Otherwise, mark it as approved so others in the future will know how to resolve the same issue.

Thanks!
Em

EmNichs
 3,235 pts.