SQL query!

[Ruslan Zasukhin]

on 9/7/03 10:59 AM, Vector Vibe at karthkyn at hotmail.com wrote:

> Dear Ruslan
> 
>>     Select  *
>>     from    TABLEB, TABLEA
>                ^^^^^^^^^^^^^^^^^
>>     WHERE   TABLEA.B_CODE=TABLEB.B_CODE AND TABLEA.B_CODE=987
> 
> is it mandatory to include both the tables in the from clause?

Yes of course. Because you do JOIN on 2 tables.
 
> I used this
>>     Select  *
>>     from    TABLEB
>>    WHERE   TABLEA.B_CODE=TABLEB.B_CODE AND TABLEA.B_CODE=987
> 
> and getting error 616 .. !?

No, you need both tables.
If you want select fields only on table you need

     Select  TableA.*
     from   TableA,  TABLEB
    WHERE   TABLEA.B_CODE=TABLEB.B_CODE AND TABLEA.B_CODE=987


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