Stephen, You could do if you wanted but the fact that the curTemp2 table is mentioned in the join is sufficient to expose all the fields and make them available in the select statement. You are using the "old fashioned" method where you include the join expression in the "where..." section and the two aliases in the "from..." section.
I must admit I never use this method now as it is not 100% compatible over all SQL dialects. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Weeks Sent: 01 August 2006 08:45 To: [email protected] Subject: Re: Wierd SQL Error - Any Ideas? * (3) This errors. Also No records Select All ; Date(2000+Val(Substr(curTemp.cDate,7,2)), ; Val(Substr(curTemp.cDate,4,2)), ; Val(Substr(curTemp.cDate,1,2))) ; as Date ; From curTemp ; <<<<<<<<<<<<<<<<<<<<<<<<<<< should be "from curtemp,curtemp2" since you are selecting from both tables ? Join curTemp2 on curTemp2.PK=curTemp.FK1 ; Where curTemp.F1="A01" ; Into Cursor curResult Dont know if this has been resolved but suggestion in line -- Stephen Weeks [EMAIL PROTECTED] -- http://www.fastmail.fm - Same, same, but different… [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
