Shouldn't that be:
select tablename.fieldname, tablename.fieldname, etc (not * when more than one table)
from timesheet t, teammaster As tm, worktype As w
inner join teammaster tm on t.teamid = tm.teamid
inner join worktype w on t.wtid = w.wtid
where t.tsid = 56403
Did that help? I would do this in the designer, and then copy the SQL from SQL View.