<html><div style='background-color:'><DIV>This statement works inside of access but
doesnt' work inside the asp code<BR><BR><BR>SELECT MAIN_CONTROL.*, R_TECR.*, Users.*<BR>FROM (Users INNER
JOIN MAIN_CONTROL ON Users.PeopleID = MAIN_CONTROL.PeopleID) INNER JOIN R_TECR ON (R_TECR.TECR = MAIN_CONTROL.TECR) AND
(Users.PeopleID = R_TECR.PeopleID);<BR><BR>thanks<BR>jonathan</DIV></div><br
clear=all><hr>Join the world?s largest e-mail service with MSN Hotmail. <a
href='http://g.msn.com/1HM1ENUS/c157??PI=44364'>Click Here</a><br></html>