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:
WHERE wantSilver = 'Yes';
What am I missing here?
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?