select tblPersonalInfo.companyname, tblJobBudget.title,tblJobBudget.userid, tblJobAdv.advtitle, tblJobAdv.userId,
tblApplication.advid, tblApplication.position
from tblJobAdv
inner join tblApplication
ON tblJobAdv.advid = tblApplication.advid
inner join tblPersonalInfo
On tblPersonalInfo.userid = tblJobBudget.userid
<div>the bolded underlined parts are creating error bcz there is no way for me to select tblJobBudget neither by INNER JOIN clause nor by From clause ,</div>
select table1.coloumn,table2.coloumn.table3.coloumn,table4.coloumn from table1 inner join table2 on table2.coloumn=table2.coloumn inner join table3 on table3.coloumn=table2.coloumn inner join table4 on table4.coloumn=table3.coloumn
then we go 2 u way
table 1=tblPersonalInfo
table2=tblApplication
table3=tblPersonalInfo
table4=tblJobBudget
..
You joined good in first 3 table but 4th table is not connect join but u got 4th table.coloumn(tblPersonalInfo.userid = tblJobBudget.userid),You
use tblJobBudget.userid but where you join this table?? for the inner join tblPersonalInfo is joined so get on tblPersonalInfo.userid,
therfor you not assign inner join tblJobBudget (Not) but u got tblJobBudget.userid.So, you get that error
Hunain Hafee...
Member
238 Points
639 Posts
inner join problem in asp.net
Dec 29, 2012 12:12 PM|LINK
i am accessing
<div>the bolded underlined parts are creating error bcz there is no way for me to select tblJobBudget neither by INNER JOIN clause nor by From clause ,</div>dotnetramesh
Member
74 Points
37 Posts
Re: inner join problem in asp.net
Dec 29, 2012 12:31 PM|LINK
Hunain Hafee...
Member
238 Points
639 Posts
Re: inner join problem in asp.net
Dec 29, 2012 12:42 PM|LINK
dotnetramesh
Member
74 Points
37 Posts
Re: inner join problem in asp.net
Dec 29, 2012 12:46 PM|LINK
Ok change tblPersonalInfo.userid =tblApplication.userid to tblJobBudget.Userid= tblPersonalInfo.userid
in my query last line
Hunain Hafee...
Member
238 Points
639 Posts
Re: inner join problem in asp.net
Dec 29, 2012 12:55 PM|LINK
@ramesh, my dear, thats why i posted here, i can't do that bcz i haven't selected JobBudget tbl , and i fi do then i throws error,
dotnetramesh
Member
74 Points
37 Posts
Re: inner join problem in asp.net
Dec 29, 2012 01:04 PM|LINK
Hey you get tblJobBudget.title,tblJobBudget.userid .But you not join the tblJobBudget table.
Please refer this
http://msdn.microsoft.com/en-in/library/ms191430(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms190014(v=sql.105).aspx
You like any otherjoin
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
http://www.datamartist.com/sql-inner-join-left-outer-join-full-outer-join-examples-with-syntax-for-sql-server
Hunain Hafee...
Member
238 Points
639 Posts
Re: inner join problem in asp.net
Dec 29, 2012 01:07 PM|LINK
yesss, thats the real problem so how to join it , i tried inner join , from,,,,
but no progress
dotnetramesh
Member
74 Points
37 Posts
Re: inner join problem in asp.net
Dec 29, 2012 01:09 PM|LINK
hai
first try this code
and Please refer this
http://msdn.microsoft.com/en-in/library/ms191430(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms190014(v=sql.105).aspx
or You like any other joins
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
http://www.datamartist.com/sql-inner-join-left-outer-join-full-outer-join-examples-with-syntax-for-sql-server
dotnetramesh
Member
74 Points
37 Posts
Re: inner join problem in asp.net
Dec 29, 2012 01:45 PM|LINK
YOU TOTALY GOES WRONG PROCEDURE
examble here
select table1.coloumn,table2.coloumn.table3.coloumn,table4.coloumn from table1 inner join table2 on table2.coloumn=table2.coloumn inner join table3 on table3.coloumn=table2.coloumn inner join table4 on table4.coloumn=table3.coloumn
then we go 2 u way
table 1=tblPersonalInfo
table2=tblApplication
table3=tblPersonalInfo
table4=tblJobBudget
..
You joined good in first 3 table but 4th table is not connect join but u got 4th table.coloumn(tblPersonalInfo.userid = tblJobBudget.userid),You use tblJobBudget.userid but where you join this table?? for the inner join tblPersonalInfo is joined so get on tblPersonalInfo.userid, therfor you not assign inner join tblJobBudget (Not) but u got tblJobBudget.userid.So, you get that error
This is your problem.fix that...
good luck
Hunain Hafee...
Member
238 Points
639 Posts
Re: inner join problem in asp.net
Dec 29, 2012 02:34 PM|LINK
solved