Saturday, December 29, 2012 1:43 PMi 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.useridthe 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
Saturday, December 29, 2012 1:56 PMhelo ?
Monday, December 31, 2012 7:36 AM
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/
Monday, December 31, 2012 9:10 AM
I think title and userid columns does not below to table tblJobBudget.
It will be helpfull if you post the exact error you get ....
Monday, December 31, 2012 4:31 PM
You need to add the tblJobBudget table to your query, by adding something like
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