[g-force2k2]

Originally Posted by ap0c

I'm running into an error running the first query

PHP Code:

 Invalid SQL: SELECT userid, usergroupid FROM user LEFT JOIN post USING (userid) WHERE user.ipaddress='xx.xxx.xx.xx' AND post.ipaddress='xx.xxx.xx.xx'
mysql error: Column: 'userid' in field list is ambiguous
mysql error number: 1052 


Try changing:

PHP Code:

       SELECT userid, usergroupid 


To

PHP Code:

       SELECT user.userid, usergroupid 


Regards,
g-force2k2