CREATE FUNCTION lms_current_user() RETURNS int(11) NO SQL RETURN @lms_current_user;

CREATE VIEW customersview AS SELECT c.* FROM customers c WHERE NOT EXISTS ( SELECT 1 FROM customerassignments a JOIN excludedgroups e ON (a.customergroupid = e.customergroupid) WHERE e.userid = lms_current_user() AND a.customerid = c.id)

zrob te dwa zapytania i zobacz jaki bedzie blad

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms