[ic] Searching on more than one table

[Tobias Henle]

patrick.bennett@ccgenesis.com wrote:

> I would like to come up with a way to search two
> tables using one search string.  I have the products
> table and the article table, both of which should
> be searched from one search box.  Is there an
> easy way to do this?


Use SQL!

** I use SQL for most of my Querys becourse of preformance.
If you debug the SQL Querys form IC you will see that it oftens siply 
uses a SELECT * FROM bla; what is not very fast ;)

** and I use SQL berourse SQL == phun! ;)

mit freundlichen Grüßen

-Tobias Henle
                          _   _    _
  __ __ ____ __ ____ __ _| |_| |_ (_)___ ___ ___ _ _    __ ___ _ __
  \ V  V /\ V  V /\ V  V /  _| ' \| / -_|_-</ -_) ' \ _/ _/ _ \ '  \
   \_/\_/  \_/\_/  \_/\_(_)__|_||_|_\___/__/\___|_||_(_)__\___/_|_|_|
--
________E-Mail________________________URL____________________________
	mailto:t.henle@thiesen.com    http://www.thiesen.com
_____________________________________________________________________