troubleshooting Question

How to pass a param to a query from within another query

Avatar of Badotz
BadotzFlag for United States of America asked on
SQL
8 Comments2 Solutions178 ViewsLast Modified:
Friends,

Is it possible to pass a param to a query from within another query?

Query1:
select Sum(hours) as total_hours from tot_hours where job_number = [@Job_Number] group by job_number;

Query2:
select j.job_number, j.job_name, q.total_hours from job_master as j, Query1 as q;

How would I pass "job_number" to Query1 from within Query2?

Or am I completely off the mark?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros