Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
talya
Starting Member
2 Posts |
 Posted - 2002-08-30 : 22:40:03
|
| Hello, I am trying to retrieve data from multiple tables using the following:Dim companyidcompanyid = Request("companyid")Select * from company, education, work, order where company.companyid = education.companyid and work.companyid = order.companyid where company.companyid = '" & companyid &"'I am getting syntax errors? |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2002-08-31 : 07:27:31
|
| You shouldn't have a table named order as it is a reserved word in SQL. It is best to rename the table. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-04 : 17:43:43
|
| You also have the word where in your statement twice. |
|
|
|
|
|
|
retrieve data from multiple tables