> Sattach EMP as EMPINFO using > EMPCODE,FIRSTNAME,LASTNAME,ZIP alais > USERID,FNAME,LNAME,ZIPCODE
Oma: Check the syntax. I think Emmit posted a reply to you about a week ago. Basically, you need to get rid of the USING clause (which specifies UNIQUE columns, NOT THE COLUMNS TO ATTACH in the SATTACH command) and then after ALIAS you need to supply an alias for EVERY COLUMN in the attached table, whether you want the column or not and whether that column needs an alias or not. -- Larry __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com
