Hi there, I have 2 querys I would like to join to get a combined result.
SELECT * FROM events,codes WHERE event_code=code_short AND event_IATA='"&Response.QueryString("location")&"' ORDER BY event_start
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