>>I'm talking about JOIN in the SQL-SERVER, not in VFP5...
>
>join does exist in sql server and the syntax is similar to vfp5 (if you can't find sql server help)

SQL Select is pratically the same because it is both ANSI-92