Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- Entities.ID,
- EntityTypes.Name as TypeName,
- PropertyTypes.Name as PropType,
- Properties.Value
- FROM
- PropertyTypes JOIN Properties ON PropertyTypes.ID = Properties.TypeID,
- Entities JOIN Properties ON Entities.ID = Properties.EntityID
- EntityTypes JOIN Entities ON EntityTypes.ID = Entities.TypeID
- ORDER BY Entities.ID
Add Comment
Please, Sign In to add comment