masooodj67
شنبه 29 خرداد 1395, 22:07 عصر
با سلام موندم چرا این کوئری جواب نمیده؟ لطفا بگید عیوب ممکنه از کجا باشه
SELECT e.personelCode, e.firstName, e.lastName, e.accountNumber, s.name, ec.score, p.prizeAmout, p.prizeTitle, b.name AS Expr1
FROM ServiceUnit AS s INNER JOIN
Book AS b INNER JOIN
EmployeeCompetition AS ec INNER JOIN
Employee AS e ON ec.employeeId = e.id ON b.id = ec.bookId ON s.id = e.currentUnitId INNER JOIN
Prize AS p ON ec.score >= p.fromScore AND ec.score < p.toScore
تاپیک رو دوباره زدم چون ظاهرا تاپیک قبلی دچار مشکل شده.یا حق
SELECT e.personelCode, e.firstName, e.lastName, e.accountNumber, s.name, ec.score, p.prizeAmout, p.prizeTitle, b.name AS Expr1
FROM ServiceUnit AS s INNER JOIN
Book AS b INNER JOIN
EmployeeCompetition AS ec INNER JOIN
Employee AS e ON ec.employeeId = e.id ON b.id = ec.bookId ON s.id = e.currentUnitId INNER JOIN
Prize AS p ON ec.score >= p.fromScore AND ec.score < p.toScore
تاپیک رو دوباره زدم چون ظاهرا تاپیک قبلی دچار مشکل شده.یا حق