How to display values in one table by referring and checking values in another table?

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

<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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EmNichs
    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
    3,250 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following