Click here to Skip to main content
15,898,010 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have two tables arts and artdetails artsId is the primary key in arts table foreign key in artdetails table. I am selecting values from both table but my query is giving error as "Invalid object name 'artdetails'" My query is:
SQL
select arts.artsId, artdetails.mainImage from artdetails INNER JOIN arts ON artdetails.artsId=arts.artsId;

Please help.
Posted
Updated 9-May-14 6:24am
v4
Comments
Codefroster 9-May-14 17:11pm    
Have u verifed syntax in query builder

You stated in your question that the table was called artsdetails but in your query you have used artdetails
 
Share this answer
 
Comments
Member 10724668 9-May-14 12:23pm    
its by mistake. My table name is artdetails only
CHill60 9-May-14 12:41pm    
And nothing is capitalized? ArtDetails for example?
[no name] 9-May-14 12:24pm    
Wow, Hawkeye indeed.
CHill60 9-May-14 12:41pm    
;-)
make sure you are select correct database from database combobox near Execute button
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900