Join Statement with two field relationship

[dhogan444]

Hello, here is the problem:



We have two tables;

tblCustomers (Fields: ID, CustomerName, PreviousIncrement, CurrentIncrement)
tblIncrements (Fields: ID, IncrementName)

I have redacted some other fields for sake of simplicity.

PreviousIncrement and CurrentIncrement are both linked to tblIncrements.ID.

How do I run a query to SELECT the CustomerName, PreviousIncrement's Name, and CurrentIncrement's Name???

Thank you

[R_Badger]

I do it using an alias (see here for me)

I would try something like:

SELECT CustomerName, PreviousIncrement as PI,CurrentIncrement as CI FROM (tblCustomers as tc INNER JOIN tblincrements as ti1 ON tc.pI=ti1.incrementname) INNER JOIN tblincrements as ti2 ON tc.ci=ti2.incrementname;

[JoeM]

Just add the tblIncrements table to your query twice, linking each one each field, and returning the IncrementName from each one.