strange error in gui_wms table

[christoph]

on our development server we have a strange occurence of GUIs without WMS at position 0. To check which GUIs were involved, I have written a (probably too complex) SQL

SELECT b FROM (

SELECT * FROM (

SELECT DISTINCT fkey_gui_id AS a FROM gui_wms WHERE gui_wms_position = 0) AS sql_a

RIGHT JOIN (

SELECT DISTINCT fkey_gui_id AS b FROM gui_wms WHERE gui_wms_position <> 0) AS sql_b

ON a = b) as sql_c

WHERE a IS NULL

Most are gui1 clones.

I wonder where this error comes from.

[anonymous]

Unstructured information management architecture Architecture enterprise sap