Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
All you need to do is to paste your code in the SQL window, and the results are rendered in the results window. You can click between the windows using the tabs.
SELECT c.*, s.*FROM tblasd cleft outer join tblS s on s.St = c.Ctwhere Office ='London'order by s.St, c.caBecomes......
SELECT c.*, s.* FROM tblasd c LEFT OUTER JOIN tblS s ON s.St = c.Ct WHERE Office ='London' ORDER BY s.St, c.ca