Can I Join query like this

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I try to join query like this but it gives syntax error on join

SELECT ti.CORP, ti.TECH, ti.TECHCONT, tj.LstVldTech, tpr.Status,
tpr.TicketNum
FROM tbl_validDisputes AS tj, tbl_PPVResearch AS tpr INNER JOIN tech_id
AS ti ON Mid(tpr.AccountNum,1,5) = ti.CORP
WHERE (((ti.TECH)=[tj].[LstVldTech]) AND
((tpr.TicketNum)=[tj].[ticketnum]));

Thanks.
 
I wouldn't advise it.

Use the JOIN (or INNER JOIN) key word for all tables. Something like:

SELECT ti.CORP, ti.TECH, ti.TECHCONT, tj.LstVldTech, tpr.Status,
tpr.TicketNum
FROM tbl_validDisputes AS tj INNER JOIN (tbl_PPVResearch AS tpr INNER JOIN
tech_id
AS ti ON Mid(tpr.AccountNum,1,5) = ti.CORP) ON
tpr.TicketNum)=[tj].[ticketnum])
WHERE (((ti.TECH)=[tj].[LstVldTech])
 
Back
Top