troubleshooting Question

Comibining 2 different Query's to get combined result

Avatar of Graeme
GraemeFlag for Australia asked on
ASPMicrosoft Access
64 Comments7 Solutions253 ViewsLast Modified:
Hi there, I have 2 querys I would like to join to get a combined result.

Query 1:
SELECT * FROM events,codes WHERE event_code=code_short AND event_IATA='"&Response.QueryString("location")&"' ORDER BY event_start
Query 2:
SELECT * FROM itins,itin_deps WHERE itins.itin_ID=itin_deps.itin_ID AND itin_depdate='"&Response.QueryString("location")&"' ORDER BY itin_depdate

Unfortunately I have no idea how to do this and Google searching for examples hasnt been fruitful (havent found any examples that look remotely correct)

So somehow I would like to join these and have 1 continuous outcome ORDER BY their date fields
ASKER CERTIFIED SOLUTION
Graeme
GPTouring

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 7 Answers and 64 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 7 Answers and 64 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