Multiple table search

[Ruslan Zasukhin]

On 3/30/05 7:16 AM, "Gregory Kowalski" <gregkowalski at earthlink.net> wrote:

Hi Gregory 

>   whichSea
rch = "select *  FROM aTable, bTable where atable.fieldtwo =
> '"&"1004"&"' OR bTable.fieldfour = '"&"1004"&"' "
> 
> and it also crashes.
> 
> What is the correct syntax?

Small ask:

    it will be more simple to read the final SQL string,
    without & & 


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]