JOIN t2 on (t2.Company = t1.Company AND t2.t1Seq = t1.t1Seq)
JOIN t3 on (t3.Company = t2.Company AND t3.JobNum = t2.JobNum AND t3.AssemblySeq = t2.AssemblySeq)
JOIN t5 on (t5.Company = t2.Company AND t5.JobNum = t2.JobNum AND t5.AssemblySeq = t3.AssemblySeq AND t5.OprSeq = t2.OprSeq)
JOIN t4 on (t4.Company = t5.Company AND t4.OpCode = t5.Opcode)
t1.Field = 'Yadda ...''
My question is about joining in table 5.
Can you use 2 tables to join in this table? (I'm using t2 and t3 when you look at it)
Actually, it does work. I just wanted to make sure that even though it worked nothing was going to blow up on me in the future.
In my mind, you should be able to do this because you're really joining in your existing record set with another table. So you should be able to join the new table on any existing fields in the current record set.