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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL - Inner Joins

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-08 : 23:43:02
Neil writes "I'd like to set up the following:-

A page which allows users to choose up to six fields which then form a search query for a database.

The database consists of 3 Tables which are linked by a common field called GradlinkID.

I seem to have a problem with the JOIN statment. I've tried copying the SQL generated by Access when I've run the query that way but the SQL doesn't seem to work on an ASP page.

Can you tell me how I can join 3 separate tables together?

Yours, desperately confused

Neil"
   

- Advertisement -