what is the database connectivity

[mmmickyyy]

a.stateId=b.stateId and a.districtId=c.districtId and b.stateId=c.stateId"

[Sandeep Mewara]

What? Your question title and the content does not look anywhere near. Please elaborate more on what are you trying and where are you stuck?

Sandeep Mewara Microsoft ASP.NET MVP 2012 & 2013 [My Blog]: Sandeep Mewara's Tech Journal! [My Latest Article]: HTML5 Quick Start Web Application

[Maciej Los]

I'm not sure what you mean, but... It's not "connectivity", it's JOIN[^] specification. Join hints specify that the query optimizer enforce a join strategy between two (or more) tables, based on a relationship between certain columns in these tables. In your example you have joined 3 tables on stateid and districtid fields. More: http://www.w3schools.com/sql/sql_join.asp[^]