SELECT Enc_SchdLine.*, Enc_Details.*; FROM Enc_Invhead ; JOIN Enc_SchdLine ON Enc_Invhead.OrderID = Enc_SchdLine = OrderID ; JOIN Enc_details ON Enc_SchdLine.RecordId = Enc_Details.Line_Id; WHERE Enc_SchdLine.Length = 0 AND; Enc_SchdLine.RatePerSpt >= 0 AND; VAL(Enc_Details.Type) = 0; INTO CURSOR temp1>I have the following code. I want to add enc_invhead to the join.
>SELECT Enc_SchdLine.*, Enc_Details.*; > FROM Enc_SchdLine; > JOIN Enc_details ON Enc_SchdLine.RecordId = Enc_Details.Line_Id; > WHERE Enc_SchdLine.Length = 0 AND; > Enc_SchdLine.RatePerSpt >= 0 AND; > VAL(Enc_Details.Type) = 0; > INTO CURSOR temp1 >