Building an SQL String that require multiple tables

<i><b>Originally posted by : Rocki</b></i><br />I'm writing a search page, which has lots of fields on it. Depending on which field user has entered search data into, an appropriate sql string needs to be built using ASP? How would I work this out if the search string requires using multiple tables (as joins will have to be done)?<br />

<i><b>Originally posted by : scott (shutch@rocketmail.com)</b></i><br />it seemd you are buiding a sql string based on user entry aka dynamic search you do not need to build multiple sql strings what you need to do is an if statement that will tell the query if this field is not selected then ="" that way you can searrch for one thing and not search for another your html form may help me a little better understand what exactly you are doing<br /><br /><br />------------<br />Rocki at 2/4/2000 5:25:55 AM<br /><br />I'm writing a search page, which has lots of fields on it. Depending on which field user has entered search data into, an appropriate sql string needs to be built using ASP? How would I work this out if the search string requires using multiple tables (as joins will have to be done)?<br />