one field is not showing in query

E

Eric

Hi: Can any one please help me as ti.techcont is not showing any thing
in query.

SELECT ti.CORP, ti.TECH, ti.TECHCONT, tj.LstVldTech, tpr.Status,
tpr.TicketNum
FROM ((select tpr.*, Mid(tpr.AccountNum,1,5) as tprCorp from
tbl_PPVResearch AS tpr) as tpr1 INNER JOIN tech_id AS ti ON
tpr1.tprCorp = ti.CORP) inner join tbl_validDisputes AS tj on (ti.TECH
=tj.LstVldTech)
WHERE
tpr1.TicketNum = tj.ticketnum

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conver string into number during join 3
Can I Join query like this 1
Run my query it prompt which i dont want 2
Pass Account Number from a user form 0
Union two queries 0
Can any one please help me out 0
Problem in query 1
Use Instr 1

Top