General question on Database behaviour/SQL

[Ruslan Zasukhin]

On 11/7/06 11:28 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

>> When you have READ ONLY cursor,
>> You can UPDATE some record of some its table with help of OTHER SQL
>> commands
>> 
>>     UPDATE ... WHERE id = xxx
>> 
>> Xxx you must extract from your first cursor.
>> 
>> Actually this is how work all mySQL developers.
>> 
>>     cursor -> id -> new update -> may be new cursor
> 
> And this is the only way? Remember I do not need data from the second table.
> Is there not something like
> 
> SELECT * FROM KUNDENTABLE IF TRUE (SELECT * FROM KUNDENTABLE,
> KUNDENKARTENTABLE WHERE KD_ID=CRD_KD_ID"
> 
> Or
> 
> SELECT * FROM KUNDENTABLE IN (SELECT * FROM KUNDENTABLE, KUNDENKARTENTABLE
> WHERE KD_ID=CRD_KD_ID
> 
> ?
> 
> Thank you and sorry for my litte SQL knowledge

Aha, you asking if its possible to modify query...

What about 

SELECT KUNDENtable.*
FROM KUNDENtable,KUNDENKARTENtable
WHERE  KD_ID !=0  AND CRD_KD_ID=KD_ID

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