>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
If it's not broken, fix it until it is.
My Blog