این هم برای ارتباط چندین جدول با هم هستش.
SELECT DISTINCT
TOP (100) PERCENT Tbl_Sabt_Motovafy.SM_ID, Tbl_Sabt_Motovafy.SM_SHS_ShomareSanad, Tbl_Sabt_Motovafy.SM_Shomare_Pavande, Tbl_Sabt_Motovafy.SM_CM_Code_Mali, Tbl_Sabt_Motovafy.SM_Meleyat,
CASE WHEN Tbl_Sabt_Motovafy.SM_Meleyat = 1 THEN N'ایرانی' ELSE N'غیر ایرانی' END AS egleyat, Tbl_category_sex.CTS_Sex, Tbl_Sabt_Motovafy.SM_NameAndLast, Tbl_Sabt_Motovafy.SM_Father,
(SELECT dbo.MakeCompleteShmsiDate(Tbl_Sabt_Motovafy.SM_Bor n, '/') AS Expr1) AS SM_Born,
(SELECT dbo.MakeCompleteShmsiDate(Tbl_Sabt_Motovafy.SM_Dea th, '/') AS Expr1) AS SM_Death, Tbl_Sabt_Motovafy.SM_Faz, Tbl_NameGete.NG_NameGete, Tbl_Sabt_Motovafy.SM_Gete, Tbl_Sabt_Motovafy.SM_Radif,
Tbl_Sabt_Motovafy.SM_Shomare, Tbl_Sabt_Motovafy.SM_Tabage, Tbl_Sabt_Motovafy.SM_AgeYear, Tbl_Bolog.B_Bolog AS SM_ID_Bolog, Tbl_Sabt_Motovafy.SM_Mahal_Dafn, Tbl_Users.U_U_Username,
(SELECT dbo.MakeCompleteShmsiDate(Tbl_Sabt_Motovafy.SM_Ins ert_Date, '/') AS Expr1) AS SM_Insert_Date,
(SELECT dbo.MakeCompleteShmsiDate(Tbl_Sabt_Motovafy.SM_Upd ate_Date, '/') AS Expr1) AS SM_Update_Date, Tbl_Sabt_Motovafy.SM_IP
FROM Tbl_Sabt_Motovafy INNER JOIN
Tbl_category_sex ON Tbl_Sabt_Motovafy.SM_Sex = Tbl_category_sex.CTS_ID INNER JOIN
Tbl_NameGete ON Tbl_Sabt_Motovafy.SM_Name_Gete = Tbl_NameGete.NG_ID INNER JOIN
Tbl_Users ON Tbl_Sabt_Motovafy.SM_U_Username = Tbl_Users.U_ID INNER JOIN
Tbl_Bolog ON Tbl_Sabt_Motovafy.SM_ID_Bolog = Tbl_Bolog.B_ID_Bolog
WHERE (Tbl_Sabt_Motovafy.SM_NameAndLast LIKE N'%' + @SM_NameAndLast + '%')
ORDER BY Tbl_Sabt_Motovafy.SM_NameAndLast, Tbl_Sabt_Motovafy.SM_ID DESC