SQL Abfrage für Rechtesystem mit Priorität

[DeddyH]

Ungetestet (evtl. müssen noch weitere Aliase verwendet werden):

SQL-Code:

SELECT DISTINCT RECHN.OBJID, RECHN.BARCODE, RECHN.ABSENDER, RECHN.RECHNR 
FROM RECHN
INNER JOIN DBACCESS ON DBACCESS.OBJID = RECHN.OBJID
WHERE DBACCESS.USERID = 101 AND DBACCESS.ACCESS = 'True'
OR (
    DBACCESS.GROUPID = 2 AND DBACCESS.ACCESS = 'True'
    AND NOT EXISTS(
        SELECT * FROM DBACCESS tmp
        WHERE DBACCESS.OBJID = tmp.OBJID
        AND tmp.USERID = 101
        AND tmp.ACCESS = 'False')
   )