azadeh_1510
چهارشنبه 24 اردیبهشت 1393, 18:29 عصر
دوستان با سلام مشکل این دستور چیست که اینزرت انجام نمیدهد؟
INSERT INTO RelationshipItems
(ChildId, ParentId, RelationshipId)
SELECT Employees.Id, Employees_1.Id, Relationships.Id
FROM RelationshipItems AS RelationshipItems_1 INNER JOIN
Employees ON RelationshipItems_1.ChildId = Employees.Id INNER JOIN
Employees AS Employees_1 ON RelationshipItems_1.ParentId = Employees_1.Id INNER JOIN
Relationships ON RelationshipItems_1.RelationshipId = Relationships.Id
WHERE (Employees_1.FullName = N'اصناف شهاب') AND (Relationships.Name = N'مرخصی') AND (Employees.FullName = N'جمشيدي آزاده')
INSERT INTO RelationshipItems
(ChildId, ParentId, RelationshipId)
SELECT Employees.Id, Employees_1.Id, Relationships.Id
FROM RelationshipItems AS RelationshipItems_1 INNER JOIN
Employees ON RelationshipItems_1.ChildId = Employees.Id INNER JOIN
Employees AS Employees_1 ON RelationshipItems_1.ParentId = Employees_1.Id INNER JOIN
Relationships ON RelationshipItems_1.RelationshipId = Relationships.Id
WHERE (Employees_1.FullName = N'اصناف شهاب') AND (Relationships.Name = N'مرخصی') AND (Employees.FullName = N'جمشيدي آزاده')