Hi Kevin,

You can put Enc_Invhead into FROM clause and join the rest of tables to it .

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.
>
>inv_head is a 1 to many into enc_schdline, which is a one to many into
>enc_details.

>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

>