General question on Database behaviour/SQL

[Florian Bogeschdorfer]

> 
> > And advice?
> 
> Do you have the link between KUNDENtable and  KUNDENKARTENtable ?
> If so you can use valentina's sql-extension such as "->" operator.
> 

I guess no, because this just returns ALL records from KUNDENtable. I did
not explicitly link the tables, I just store the KD_ID from KUNDENtable in
the KUNDENKARTENtable as well as CRD_KD_ID and this is how I link the
tables.

Must I change this to ObjectPtr Links? Can I do this with existing records?

Best, FLorian

> Something like this:
> SELECT * FROM KUNDENtable WHERE  KD_ID !=0  AND KD_ID->CRD_KD_ID = KD_ID
>