>There has to be something going wrong somewhere. It would be interesting if you put up an example of your SQL, it would help in reaching to the source of your problem.
here it is (ie the [non-editable!] SQL code generated by the remote view builder):
SELECT Mainpatient.firstname, Mainpatient.lastname,;
Scdirectory.firstname, Scdirectory.lastname;
FROM {oj mainpatient Mainpatient LEFT OUTER JOIN SCdirectory Scdirectory ;
ON Mainpatient.attendingmd = Scdirectory.dirid }