gate.getBonds().sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of gate Show documentation

A multipurpose java library

There is a newer version: 12.3.1

select
    RoleFunc.Role$id as 'role.id',
    null as 'user.id',
    Func.id as 'func.id',
    Func.name as 'func.name'
from
    RoleFunc
        join
    Func ON RoleFunc.Func$id = Func.id
union select
    null as 'role.id',
    UzerFunc.Uzer$id as 'user.id',
    Func.id as 'func.id',
    Func.name as 'func.name'
from
    UzerFunc
        join
    Func ON UzerFunc.Func$id = Func.id