inner join problem

Question

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

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 

Answer 1

helo ?

Answer 2

Hi

Is  attribute "title' and 'userid' belongs to the table  tblJobBudget ?

Please check it and spelling mistake also .

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

Answer 3

I think title and userid columns does not below to table tblJobBudget.

It will be helpfull if you post the exact error you get ....

Answer 4

You need to add the tblJobBudget table to your query, by adding something like

JOIN tblJobBudget
ON <something>

And somewhere there must be a column in the tblPersonalInfo or tblJobBudget tables that can be connected to either the tblJobAdv or tblApplication tables.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty