inner join problem in asp.net RSS

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  inner join problem in asp.net

  Dec 29, 2012 12:12 PM|LINK

  i am accessing 

  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>
  Hunain Hafeez
  • Edited by Hunain Hafeez on Dec 29, 2012 12:13 PM
  • Edited by Hunain Hafeez on Dec 29, 2012 12:13 PM
  • Edited by Hunain Hafeez on Dec 29, 2012 12:14 PM
  • Edited by Hunain Hafeez on Dec 29, 2012 12:15 PM
• • Reply
  

  dotnetramesh

  Member

  74 Points

  37 Posts

  Re: inner join problem in asp.net

  Dec 29, 2012 12:31 PM|LINK

  You not assign inner join in tblJobBudget table.

   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 =tblApplication.userid inner join tblJobBudget on tblJobBudget.PrimaryKeyId=tblApplication.PrimaryKeyId

  Refre this

  http://msdn.microsoft.com/en-us/library/aa213227(v=sql.80).aspx

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: inner join problem in asp.net

  Dec 29, 2012 12:42 PM|LINK

  dotnetramesh

  On tblPersonalInfo.userid =tblApplication.userid inner join tblJobBudget on tblJobBudget.PrimaryKeyId=tblApplication.PrimaryKeyId

  i want

  On tblPersonalInfo.userid =tblJobBudget.Userid 

  not

   On tblPersonalInfo.userid =tblApplication.userid

  Hunain Hafeez
• • Reply
  

  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

  • Edited by dotnetramesh on Dec 29, 2012 12:46 PM
  • Edited by dotnetramesh on Dec 29, 2012 12:46 PM
• • Reply
  

  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, 

  Hunain Hafeez
• • Reply
  

  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

  • Edited by dotnetramesh on Dec 29, 2012 01:08 PM
• • Reply
  

  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

  Hunain Hafeez
• • Reply
  

  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

  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 =tblApplication.userid inner join tblJobBudget on tblJobBudget.Userid= tblPersonalInfo.userid

  
  
  

   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

  • Edited by dotnetramesh on Dec 29, 2012 01:09 PM
  • Edited by dotnetramesh on Dec 29, 2012 01:09 PM
  • Edited by dotnetramesh on Dec 29, 2012 01:12 PM
• • Reply
  

  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

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: inner join problem in asp.net

  Dec 29, 2012 02:34 PM|LINK

  solved 

  SELECT tblApplication.advid, tblApplication.scrdoc, tblApplication.position, tblJobAdv.advtitle, tblJobBudget.title, tblPersonalInfo.country, tblPersonalInfo.city,tblPersonalInfo.companyname
    FROM tblApplication
    INNER JOIN tblJobAdv
    ON tblApplication.advid = tblJobAdv.advid
    INNER JOIN tblJobBudget
    ON tblJobAdv.jbid = tblJobBudget.jbid
    inner join tblPersonalInfo
    On tblPersonalInfo.userid = tblJobBudget.lastmodifiedby
    where tblApplication.position  = 'selected'

  
  
  

  Hunain Hafeez
  • Edited by Hunain Hafeez on Dec 29, 2012 02:35 PM
  • Edited by decker dong - msft on Dec 30, 2012 01:02 AM
  • Edited by decker dong - msft on Dec 30, 2012 01:02 AM
  • Edited by decker dong - msft on Jan 04, 2013 03:49 AM
  • Marked as answer by decker dong - msft on Jan 04, 2013 03:49 AM