MSSQL Search Statement

msfdisk · 15-Mar-2007, 11:05 PM #1

I'm new to MSSQL. I need to develop 2 Search Functions based on several dropdowns, fields, etc. Most "criteria" are in different tables.

What is the best way to effeciently do this?

Thanks

Rockn · 18-Mar-2007, 08:47 AM #2

What are you using as the interface for the search? I think it is more Dependant on the application you are using than MSSQL.

msfdisk · 18-Mar-2007, 10:22 PM #3

My pages are developed in PHP...
Several tables are not related.

Quote:

Originally Posted by Rockn

What are you using as the interface for the search? I think it is more Dependant on the application you are using than MSSQL.

MMJ · 19-Mar-2007, 12:39 PM #4

Use the select statement.

Rockn · 19-Mar-2007, 01:46 PM #5

Quote:

Originally Posted by MMJ

Use the select statement.

Gee really! The problem is running it against several tables that have no relationship. You could set up a submit button for each text field or use something like SWITCH based on which text field is not empty on your form.

MMJ · 19-Mar-2007, 02:13 PM #6

I don't see whats so hard about it, I've done it before.

Rockn · 19-Mar-2007, 06:57 PM #7

Well maybe our friend could post some code and you could hook him up?

msfdisk · 19-Mar-2007, 09:56 PM #8

I did a select...
where criteria
UNION ALL
select...
where criteria
UNION ALL

that got me alot of NULL values
since the tables are not in relation, is there a way to somehow group these unrelated tables?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

MSSQL Search Statement

Find the solution to your computer problem!

Find the solution to your
computer problem!