Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select w.*,l.objectname as 'Location'
- from ScheduledWork sw
- left join Work w on w.ScheduledWorkID=sw.objectid
- left join [Location] l on l.objectid=w.locationid
- where sw.objectnumber='SWO/1909/0024'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement