Help with query: Join, Limit and Count total rows?

Help with query: Join, Limit and Count total rows?

El Forum
Unregistered

11-18-2008, 12:49 AM

[eluser]little brittle[/eluser]
I keep getting this error no matter what I try:
#1054 - Unknown column 'posts.userid' in 'on clause'

If I take out the JOIN, it returns results without the user.username field. What can I do to fix this?

Messages In This Thread

Help with query: Join, Limit and Count total rows? - by El Forum - 11-17-2008, 09:46 PM

Help with query: Join, Limit and Count total rows? - by El Forum - 11-17-2008, 10:38 PM

Help with query: Join, Limit and Count total rows? - by El Forum - 11-17-2008, 10:52 PM

Help with query: Join, Limit and Count total rows? - by El Forum - 11-18-2008, 12:49 AM

Help with query: Join, Limit and Count total rows? - by El Forum - 11-18-2008, 01:15 AM

Help with query: Join, Limit and Count total rows? - by El Forum - 11-18-2008, 01:37 AM