You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT Farmer FROM Farms WHERE EXISTS
(SELECT*FROM Landowners
WHERELandowners.Name=Farms.Farmer)
but not working:
SELECT Farmer FROM Farms WHERE EXISTS
(SELECT*FROM Landowners
WHERELandowners.Name CONTAINING Farms.Farmer)
(and not working with like, result is NULL)
For example 'LISA' as Farmer and 'MONALISA' as Landowners.Name
'MONALISA' CONTAINING 'LISA' but EXISTS in this query returns NULL.
Alone EXISTS returns correct dataset.
The text was updated successfully, but these errors were encountered:
Submitted by: Paweł Krzyżanowski (zpksoft)
in
https://firebirdsql.org/manual/nullguide-predicates.html
is code:
but not working:
(and not working with like, result is NULL)
For example 'LISA' as Farmer and 'MONALISA' as Landowners.Name
'MONALISA' CONTAINING 'LISA' but EXISTS in this query returns NULL.
Alone EXISTS returns correct dataset.
The text was updated successfully, but these errors were encountered: