SELECT tUserFunction.UserID, tUserFunction.FunctionID
FROM tUserFunction LEFT JOIN
    tFunction ON tUserFunction.FunctionID = tFunction.id





SELECT tUserFunction.UserID, tUserFunction.FunctionID
FROM tUserFunction cross JOIN
    tFunction




SELECT DISTINCT uf1.UserID, uf1.FunctionID, uf2.FunctionID, uf3.FunctionID,
 uf4.FunctionID, uf5.FunctionID, uf6.FunctionID, uf7.FunctionID,
 uf8.FunctionID, uf9.FunctionID, uf10.FunctionID, uf11.FunctionID,
 uf12.FunctionID, uf13.FunctionID, uf14.FunctionID, uf15.FunctionID
FROM (((((((((((((tUserFunction uf1
left JOIN tUserFunction uf2 on uf1.userid = uf2.userid and uf1.id < uf2.id)
left JOIN tUserFunction uf3 on uf1.userid = uf3.userid and uf2.id < uf3.id)
left JOIN tUserFunction uf4 on uf1.userid = uf4.userid and uf3.id < uf4.id)
left JOIN tUserFunction uf5 on uf1.userid = uf5.userid and uf4.id < uf5.id)
left JOIN tUserFunction uf6 on uf1.userid = uf6.userid and uf5.id < uf6.id)
left JOIN tUserFunction uf7 on uf1.userid = uf7.userid and uf6.id < uf7.id)
left JOIN tUserFunction uf8 on uf1.userid = uf8.userid and uf7.id < uf8.id)
left JOIN tUserFunction uf9 on uf1.userid = uf9.userid and uf8.id < uf9.id)
left JOIN tUserFunction uf10 on uf1.userid = uf10.userid and uf9.id < uf10.id)
left JOIN tUserFunction uf11 on uf1.userid = uf11.userid and uf10.id < uf11.id)
left JOIN tUserFunction uf12 on uf1.userid = uf12.userid and uf11.id < uf12.id)
left JOIN tUserFunction uf13 on uf1.userid = uf13.userid and uf12.id < uf13.id)
left JOIN tUserFunction uf14 on uf1.userid = uf14.userid and uf13.id < uf14.id)
left JOIN tUserFunction uf15 on uf1.userid = uf15.userid and uf14.id < uf15.id
where uf1.userid = 6



SELECT uf.UserID, tUser.UserLogin, tUser.FirstName, tUser.SurName, uf1.FunctionID AS "F1",
 uf2.FunctionID AS "F2", uf3.FunctionID AS "F3", uf4.FunctionID AS "F4", uf5.FunctionID AS "F5",
 uf6.FunctionID AS "F6", uf7.FunctionID AS "F7", uf8.FunctionID AS "F8", uf9.FunctionID AS "F9",
 uf10.FunctionID AS "F10", uf11.FunctionID AS "F11", uf12.FunctionID AS "F12", uf13.FunctionID AS "F13",
 uf14.FunctionID AS "F14", uf15.FunctionID AS "F15", uf16.FunctionID AS "F16"
FROM (((((((((((((((((SELECT DISTINCT UserID
FROM tUserFunction) AS uf
LEFT JOIN tUser ON uf.UserID = tUser.ID)
LEFT JOIN tUserFunction uf1 ON uf.userid = uf1.userid AND uf1.Functionid = 1)
LEFT JOIN tUserFunction uf2 ON uf.userid = uf2.userid AND uf2.Functionid = 2)
LEFT JOIN tUserFunction uf3 ON uf.userid = uf3.userid AND uf3.Functionid = 3)
LEFT JOIN tUserFunction uf4 ON uf.userid = uf4.userid AND uf4.Functionid = 4)
LEFT JOIN tUserFunction uf5 ON uf.userid = uf5.userid AND uf5.Functionid = 5)
LEFT JOIN tUserFunction uf6 ON uf.userid = uf6.userid AND uf6.Functionid = 6)
LEFT JOIN tUserFunction uf7 ON uf.userid = uf7.userid AND uf7.Functionid = 7)
LEFT JOIN tUserFunction uf8 ON uf.userid = uf8.userid AND uf8.Functionid = 8)
LEFT JOIN tUserFunction uf9 ON uf.userid = uf9.userid AND uf9.Functionid = 9)
LEFT JOIN tUserFunction uf10 ON uf.userid = uf10.userid AND uf10.Functionid = 10)
LEFT JOIN tUserFunction uf11 ON uf.userid = uf11.userid AND uf11.Functionid = 11)
LEFT JOIN tUserFunction uf12 ON uf.userid = uf12.userid AND uf12.Functionid = 12)
LEFT JOIN tUserFunction uf13 ON uf.userid = uf13.userid AND uf13.Functionid = 13)
LEFT JOIN tUserFunction uf14 ON uf.userid = uf14.userid AND uf14.Functionid = 14)
LEFT JOIN tUserFunction uf15 ON uf.userid = uf15.userid AND uf15.Functionid = 15)
LEFT JOIN tUserFunction uf16 ON uf.userid = uf16.userid AND uf16.Functionid = 16