You still need to set star per table even though you want all from each.

<cfquery datasource=#db# name=test>
SELECT news.*, users.*
FROM news, users
WHERE news.userid = users.userid
</cfquery>