I have two tables, USERS and ART. Both contain a USERID field, which is a number linked to both.
When I output from the art table, I want to display the userNAME of the person, rather than their userID.
I've established I need to use JOINS. But after spending EIGHT HOURS on this today, nothing is working and I don't know why!! Also, do I link the IDs or do I link the art.USERID with the users.USERNAME? I keep getting conflicting info but I would have thought with the IDs being linked already it'd be the username?? :/
Seriously, what's wrong with this!
<cfquery name="catdetails" datasource="062105cs06sr">
SELECT users.username, users.userid, art.arttitle, art.arturl, art.artcat, art.artdatecreated, art.artdescription, art.keyword
FROM ( art
INNER JOIN users
ON 'art.userid' = 'users.userid' )