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])


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Eric" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>