Searching Multiple tables

[Ruslan Zasukhin]

on 8/30/03 12:03 AM, Chuck at rwc1717 at shaw.ca wrote:

> On Friday, August 29, 2003, at 02:41 PM, Chuck wrote:
> 
> The syntax is "SELECT fields FROM tables WHERE (some condition holds).
> So your SQL should read something like
> 
> select * from cTable,  nTable where incid='"+incvalue+"'"
> 
> Lists of field and table names are delimited by commas, and "*" means
> all fields (excluding recID and method fields).
> 
> Charles Yeomans
> 
> I know what it 'should' look like.  I also could not figure out the problem,
> as I am used 
> to doing what you described with the delimiters.
> 
> However, my second table was not searched and a duplicate record made until I
> removed that comma...a bug I guess?
> 
> Go figure...and I just tested it again and the commas are out.....

Chuck,

Must be as Charles show you.
This 100% works.

In your first letter you have

    "select for cTable nTable where incid='"+incvalue+"'
         ^^^^^^^^^ 

Where are fields ?
Where is word FROM ?

It looks you do 2 mistakes at least

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------