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

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