I'm having a problem and I hope someone can offer some help. Let me start by saying I'm not looking for someone to do my work for me. I'm looking for someone to help me understand what I'm doing and how to do it. Ok, what I'm trying to do is retrieve data from two tables in one query. I'm on step 1 in the assignment details on the left side of the picture. I have the code to pull the info, but I can't figure out how to join the results into on table. When I type in the JOIN command, it's always dark gray, unlike the SELECT, and ORDER BY, which are blue. Is this a problem? Also, even though I have the primary key in my customer table and foreign key in my Orders table set to CustomerID, and they are associated with eachother, I keep getting the error in the picture. Can someone please help me with what I'm doing wrong here? I don't want you to do it for me, just explain what I'm doing wrong.