[rrr]

Originally Posted by Logician

SELECT f.field8, u.username, u.usergroupid, u.userid
FROM user u
LEFT JOIN userfield f ON u.userid = f.userid
WHERE usergroupid =10

Thanks! I put that in the Query box and in the Query Result Row area I put:

$WQfield[field8]

And in my webtemplate I put the call to that new webquery I created:

$WQ_newquery

But the field8 doesn't show up when I view the page. Any suggestions?