5 lines
168 B
SQL
5 lines
168 B
SQL
select II.ItemID, dbo.ve_GetPath(II.[ItemID]), Text from Parts PP
|
|
join Items II on II.ItemID=PP.ItemID
|
|
join Contents CC on II.ContentID = CC.ContentID
|
|
|
|
where FromType=7 |