>Hi.
>I always ran into a problem in VFP joins , running over the max no. of columns when joining two or more tables.
>Anybody know if there is a limit in Sql Server when joining a number of tables ?
>Tia
>
>regards,
>Gerard

I don't think there is a limit for number of JOINs in SQL Server, but you can check SQL Server limitations in BOL. See http://msdn.microsoft.com/en-us/library/ms143432.aspx