[Solved] What’s the problems on this sql command code? [closed]

by


It looks a bit bulky, I’d recommend you to rewrite it in the following way:

     SELECT User1.NAME,User1.PORT,User1.IP,File1.SIZE, 
     FROM [User_File],[User1],[File1] 
     WHERE  [User_File].UID= User1.UID AND [User_File].FID=File1.FID and [User_File].FID = {0}

and check if it runs without errors from your SQL Management Studio.

solved What’s the problems on this sql command code? [closed]