Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
None
-
None
-
2018-09, 2018-10, 2018-11, 2018-12, 2018-13
Description
Hi,
The following is complaining that a and b are not joined. it is my understanding that this should work : https://mariadb.com/kb/en/library/subquery-limitations/
select * from a where (x,y) not in (select distinct x,y from b);
workaround is a little longer to write