Group By Or Order By

I am trying to list all items in a table by their category and in priority number I have used

"SELECT * FROM FAQs LEFT JOIN FAQCategories ON FAQs.CategoryID=FAQCategories.FAQCID GROUP BY CategoryID ORDER BY FAQPosition";

but it doesn't work does anyone have any ideas??

Thanks

You must reference the tables in the group by and order by clauses.

group by FAQs.CategoryID...etc

I did I tried

$dbQuery="SELECT * FROM FAQs LEFT JOIN FAQCategories ON FAQs.CategoryID=FAQCategories.FAQCID GROUP BY FAQ.CategoryID ORDER BY FAQ.FAQPosition";

and I got

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in (and then the line in my code)

Any other ideas?