SQL and API methods + benchs

[Ruslan Zasukhin]

On 1/24/05 7:44 AM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

> I have a crash if I use:
> SELECT zipcode, cityname, namestreet FROM zipcity, street where zipcode =
> '75000' 

And you say that you use BinaryLink for tables?

Then try also THIS syntax:

 SELECT zipcode, cityname, namestreet
 FROM zipcity JOIN street ON linkname
 where zipcode = '75000'
    
I.e. Specify link name


> With 
> SELECT zipcode, cityname, namestreet FROM zipcity join street on
> linkCityStreet where zipcode = '75000'
> That works perfectly.

I think, here works old-good JOIN, based on 2 fields.

This join works always, even if you did not make FOREIGN KEY.


-- 
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
-------------------------------------------------------------