Unabel to crawl/search multiple tables (external database sQL) in SP 2010

hi everyone,

I was able to crawl a table (from an external SQL database) via SP 2010 and search it and it works great. However, I wanted to have SP crawl multiple tables from that same database and it's not happening. For some reason, it only returns results from that 1 table. I've checked the ECT settings and they have CRUD permissions on all the tables. I don't know what to do.

Any ideas??? thanks!

Who is Participating?
mo1oneConnect With a Mentor Commented:
One ECT corresponds to one Entity. Unless you have a View in ECT which gets data from multiple tables by using SQL Join inside the view Or a SQL query with multiple joins to view the data.

This view or a query with join will be helpful for only reading data and you may not be able to do CRUD operations on that.

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.