Error: 1142 INSERT command denied to user

The user I am using is the same for both databases, yet I am getting this denied error message. I can do a simple insert into each database, I just can’t insert into one from the other. Here is my insert query:

INSERT
INTO convert2silver.people
( IPaddress
, dateAdded
, firstName
, lastname
, city
, state
, zip
, country
, email
, career
, referURL)
SELECT IPaddress
, date
, firstname
, lastname
, city
, state
, zip
, country
, email
, member
, referURL
FROM oils.users
WHERE wantSilver = ‘Yes’;

What am I missing here?

Thanks!

In the WHERE CLAUSE you should use table_name.wantSilver replacing table_name with the actual name of the table.

Are you are the two tables involved in separate databases?