Column not found error on alias

1

Hello, I'm trying to insert identities to foreign keys. Here's my code:

WITH p AS (SELECT id FROM tbl_place WHERE txt_place = "Place 1")
INSERT INTO tbl_sheet(txt_rep_no, txt_song_name, id_place, id_source_by, id_compiled_by, id_notation_by, id_type, blob_sheet1)
VALUES("1", "Song Name 1", p.id, 1, 1, 1, "", "")

This gives me error

No such column p.id

How can I select and insert to foreign key?.

Edit:
Here's my code so far:

INSERT INTO "tbl_sheet" (
    txt_rep_no, 
    txt_song_name, 
    id_place, 
    id_source_by, 
    id_compiled_by, 
    id_notation_by, 
    id_type, 
    blob_sheet1,
	blob_sheet2
) 
SELECT 
    "1", 
    "Song 1", 
    p.id, 
    so.id, 
    c.id, 
    n.id, 
    t.id, 
    "iVBORw0KGgoAAAANSUhEUgAAAy8AAADSCAIAAADMq2g9AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACLlSURBVHhe7d3/T9z3fcDx/U8nNbGsSEiWrUQWkh3ZuKUzZSHuUQ8z6p7jmoS60IRcrjNExh4tPRdCrjU4ppdc63NGyVydvNHbqICNXhVNTNOYqglNK9I0oWqKutf783693/e5Lzh4vfscJM+XHj+Q9/sD3B2Ye+pzH8if/IFhGIZhGIZp3VBjDMMwDMMwrZxyjZ2tmcWPP/G+1PllXXWT39j1u+e/8pKuusmt7vjd7pd7ddVN9u+3/e7LX+vXVTfv/e2/+93e/iu66ubuL/7F7/Z941VddfPuz3/jdwe+Oayrbmby6373G0Nv6qqb9Af/4Hevjozpqpvv3X/sd19985auurk19zd+9/p3p3TVzdvvfuh3R95+R1fd3PjhB3539PZdXXXz1vff87upqQVddfPGrR/53bHpn+mqm+Hxab97M7Ooq26GUt/zu7fnf6GrbgbfuOl3v/+Tv9NVN698+y/97p2f/kpX3Vx+9Q2/+86H/6Srbvpfue53f/TRx7rq5s+/fs3vzhX+VVfdxPsu+937y7/VVTc98T6/+/7Kf+qqm6+89FW/+7P1/9ZVN18+3+13Pyz9XlfdfPGLX/K7ouPcOd1w89e/+V+/2/mn53XVzYN//B+/2/VnL+uqmw9+9V9+96WvXtRVNwvF//C7Fy4O6Kqbe4//ze9+7S+u6qqbHz/6Z797KTGkq25mF3/td79+7Tu66uaHD1b97pVvpXTVzdT7v/S73/zO27rqZvK9gt99LflXdtHPxI+X/O63b6R11c34O3m/+/rNd3XVzXfTWb+bnJzXVTdvTs77XTlSV93IR/O78ll01Y3cEr8rt1BX3ci98LuT7xXsoh95BPzu1PtFXXVz5Vtv+V15VHXVjTzyfle+IrrqRr5qfle+mrrqRr7ifle+E3TVjXy3+F35LtJVNy9duOh35TtQV93Id6nfle9eXXUj3+F+V77zddWN/Ovwu0L+7eiGm4el3/td+Xenq27k36bflX+zuupG/l37Xfn3rqtu5GeC35WfFbrqRn6e+F35OaOrbuRnkd+Vn1G66kZ+jvld+fmmq27kZ6DflZ+NuupGfn76Xfm5qqtu5Gev35WfybrqRn5u+135ea6rbsamf+p35blAV93I84XflecRXXUjzzV+V56DdNWNPE/5XXn+0lU38hznd+W5T1fdvDp6y+/K86auupHnVr8rz7m66kael/2uPF/rqht5Tve78lyvq26kB/yudIKuuuntT/hdaQxddSMd4nelT3TVjTSM35W20VU30j9+V7pIV91IO/ldoauh0QKjxsJDjYWHGgvP577G3tJVN9Icfvfg1Jis+F1qjBrTVTfUWHiosfAcxBoLvxsAAAAazkaXFhg1BgAAEDEbXVpg1BgAAEDEbHRpgVFjAAAAEbPRpQUWrrGq4wAAANA8WmDUGAAAQEtogVFjAAAALaEFRo0BAAC0hBYYV/EDAABEzEaXFhg1BgAAEDEbXVpg1BgAAEDEbHRpgVFjAAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDhGqs6DgAAAM2jBUaNAQAAtIQWGDUGAADQElpg1BgAAEBLaIFxFT8AAEDEbHRpgVFjAAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBUWMAAAARs9GlBRausarjAAAA0DxaYNQYAABAS2iBUWMAAAAtoQVGjQEAALSEFhhX8QMAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBUWMAAAARs9GlBUaNAQAARMxGlxYYNQYAABAxG11aYOEaqzoOAAAAzaMFRo0BAAC0hBYYNQYAANASWmDUGAAAQEtogXEVPwAAQMRsdGmBUWMAAAARs9GlBUaNAQAARMxGlxYYNQYAABAxG11aYNQYAABAxGx0aYFRYwAAABGz0aUFFq6xquMAAADQPFpg1BgAAEBLaIFRYwAAAC2hBUaNAQAAtIQWGFfxAwAARMxGlxYYNQYAABAxG11aYNQYAABAxGx0aYFRYwAAABGz0aUFRo0BAABEzEaXFhg1BjTKT37527fGb7/yORi5m3Jnq+4+AGD/bHRpgYVrrOo4AE9FGuWjjz763edg5G7Kna26+wCAp6UFRo0BjfLKK69orXwORu5s1d0HADwtLTBqDGgUagwA8FS0wKgxoFGoMQDAU9EC4yp+oFH2rrHF1/6kck794GPdimR+Hvr8DfrUtTW2MNUfq5yBXMUBB1duLBYbS4ffaIDt0Z5Y59S2vJ2+HotdX6vcBfB5Z6NLC4waAxrlyTX22s/1P373u49/cCrCIDMp1v6DX+t/fZxub8inrl9jPdkFv2LK5pAEGTUGIHI2urTAqDGgUfZdYzK1K82amvyST12Os//3fHqN1Vs56JpTYwBQy0aXFhg1BjTK09SYOT3WntZGMsFU8zLi4qCuuUXzLv6DmHcZXLRvmjNtOq/ZpYqpPDdWNeXPoh8tmF//wN2gPd9xPzVWGTdrA/b1y/AJs+Vsp665RXmX8geRd+kfXXbrbuomjjn/ZCd0G8ovnlbcsJpb4m+neyM4m5WVnApGVvy7hFqtfOPdjQwv9owNcG4MwN5sdGmBUWNAozxNjQUZZAPI1JKtqKCr/KIrMznSdltVgdkPWLXoCy885eSqzLXQabPw+4Zubfm2Vc++asykiS2V0IkiUzzlRe0hc6QNncoC0w9YlWWhJLLKR5r0CX0iPTLUQ6Fb4m+eP9K9EbRd+Ua6j2OazLWgebs65qrvpr5NjQGoZaNLC4waAxrl/1dj5SyT8fVj3qh+l+CUVbDr36gY81nq1pgbc4CZeifbyv23d4GF5+lqrJxlwidLEDpV7xLKqXJXhQSnu7SxyoL0KZ9yC1S8u6+9ilvi1K0x10+htytjq3zLzbr57PXvZsVHAwDLRpcWWLjGqo4D8FSepsb8uajKE1rhEgqCzI57X9dPslURcHba2/c4N1Y5PtpcnJXHfOrQCbMnzb5qrKZygvVQ09ggs+PfV0NHtirKxk5nT70aE+ZT6ARZFvrIOsFHq7gl4fetuJ2fWmPl10DdmPXKDy7vSI0BeDItMGoMaJSnqLHgwiy7Uv/cWGhMHrlF+7qkvEu4z1yBVYadjgu48vjDareCqXcbamc/NWYqxK7scdIopOpFwP7RXLYz3Ge+curmVIg/eeZjqEJTzo05nBsD8JS0wKgxoFH2XWMmg8rnn8r1E6wHZVZxgkoO8G/r9fX+4vryu9iTZLXnxoKYC12Mbw7T/wx/FhOF+nbo1ppPV/9C/k+vMVM2/tXDyo7RZAldehUc4F9qNPki4wum/C7msNoaq/jUvpPMe+mRPtEqbom/Af5I98an11j4xpsIs28HN88eHCxSYwCeTAuMGgMa5ck1VjH+ZFgwQTAF46vL5pFOuIcqS04miDAzwTmzqo+s448xU3HeK/RZQuvafGbqnDwLpn6NVUzVKSiTL3Z8ddlk0Qn3iqmi0GEaYTLBObPqj2xowJkp74ZuUvhdyrckFIhPW2MVN768WP7gYwO8Ugng02iBcRU/0Ch711gjR/qp9gRY4+fnrz35s9TWWCOZ0LGnsppDPj55BKClbHRpgVFjQKNEUmOLDfnbrfuZj9PtTwiyptaYOafV7FrKjXG+CkAL2ejSAqPGgEZpeo3tcWVY46f66rQ607Qasy9KNvPEmHsxMfRKKABEzUaXFhg1BjRKJOfGDso09dwYAHzm2ejSAqPGgEZ5a/z2Rx99pLXymR65m3Jnq+4+AGD/bHRpgVFjQKP85Je/lUZ55XMwcjflzlbdfQDA/tno0gIL11jVcQAAAGgeLTBqDAAAoCW0wKgxAACAltACo8YAAABaQguMq/gBAAAiZqNLC4waAwAAiJiNLi0wagwAACBiNrq0wKgxAACAiNno0gKjxgAAACJmo0sLjBoDAACImI0uLbBwjVUdBwAAgObRAqPGAAAAWkILjBoDAABoCS0wagwAAKAltMC4ih8AACBiNrq0wKgxAACAiNno0gKjxgAcFrnHa6lUsqc3/sLxMx29g3038unHu+UDVkujg4NdFxNWz5Vbw9PF+dXyuwPAwWGjSwuMGgNwGOzO3x07HauZ5/qv3d/O22NWin3P63J52pPjhVCxAcDBYKNLC4waA3Dw5R/le45JW53pm1pb2AgWN7Zn7iRfkLXnR8btGTJbY2dvpYPzYblCcfjKGdNjr6/lSuUPBQAHgY0uLTBqDMBBV9pJJzulqzrGS7mq9VS3XTenxyprTOQXZztkuzc7bwMOAA4MG11aYOEaqzoOAA6E1dKQxNiz/aOPql9z1N66kM1Ib9XUWO5Buj0WO3opT40BOJi0wKgxAAddsdB3PBZrH5tc2WPr1FhatmyNnRwZzZVmFkvpe9m+c1JqJ+LTW3phGQAcMFpg1BiAgyC/sj3/eEsVdyp2l5fix2KxF8snvcqKQYE9nzShVucq/vaem2sL1ReN7eaW3Sd6vLWwwjX+AFpGC4waA9B6pZ3JoXYtKBn7yqPfXSkOyOaxkYnl0GIgX8j3POdenbQ1djQ+cGNuODViPtzZW5PF6ndZXF27Zs6Z6ZxOVV6LBgAR0gLjKn4AB8Bu5u7ctWTaGrpTeUJrYyt16UgsdiaRrTxn9vEnC/eSbbFY25Ulc3z4ujF3gf/pVM0vVG5sTU7qJxKjWV7HBNACNrq0wKgxAAfe7vz04NFY7OjFbCb8YuVqaahHKq297+62+c+qq/iXC33m/Fh8eLG64QCg5Wx0aYFRYwAOgdXS8AUJr9gznSPXpgrpB8XxyXT8nFlpG8hn1oNjqmrMNNxIm204ewAAHBg2urTAqDEAh8NKafSq+atjoTnScT1fPltWXWOfLK5vBg13Ij7Ly5EADhYbXVpg1BiAQyS/vJm+mx+9nU3dW8sUK38dsrQz/6iUebSdD10oli9uZRZLmcIONQbgQLHRpQVGjQEAAETMRpcWWLjGqo4DAABA82iBUWMAAAAtoQVGjQEAALSEFhg1BgAA0BJaYFzFDwAAEDEbXVpg1BgAAEDEbHRpgVFjAAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBhWus6jgAAAA0jxYYNQYAANASWmDUGAAAQEtogVFjAAAALaEFxlX8AAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBUWMAAAARs9GlBUaNAXiy3KNCajI7sbhTtV5r/0fij7Y7n82PTi2li1XrAA4HG11aYOEaqzoOQEMs3EvHLya61GBfci51r7SwXn3YQbU7Pz34TCzWeXszX71VZf9HHjL5R9muttgLQ4WFUvVWy5S2Jwbb5cG+9nC3equhgu/ewb7ba7mDc9+BzxAtMGoMaLLdzO3+WO2cHBzObdccfABRY5/kF2c7YrGjA/n5jeqtlomoxvRrenyoeIBKFPgM0QKjxoAmszV2pGd6K2iU3YVHxdHrcXmGiz2XGF1q7omNRqDGjNzy1sE6nRnVubH52ZGjsVj765wbA5pCC4waA5qsqsYCpZ2ZcXPC7PigefEr/7iQuDySuFMYTyaOm/Nm7QP3t/PLa6lUsvPFI2Yh1t55PZsuuufd1c3U64kXgo3ynL2VXnUf39hdWFwaGkq0PxfsHov33SzO255Y30xdH4m/nk2NJ0+3BbunEonpUvnpdn1zIjVy+pjZaetJJq50yxv1G2vvIxeys/HLY6P3CkOXO832scHxx+aOZ+7Oxs/aO3Xk9JXZyYLeKXP8QHLoTjbRK5Ehqdrd83o+U3GPTIKkx5M9A2OppfKlabml/MDAYHzcnLzJF9dGr/cHj6E8ZonEHXenNrbldvbIp1t2H8o8CIM9g9kZ+RT2AUktTdwZ6wjuy+lUKec+vgi+QPIpTJHYL9bAeHboardJavk8V+bSha30ZLIjeDCfOTsydN99rde3JqfS8Z7gHsmRl26l/EV1cl+mxjr0tvqJDweBnltcSly073Xk9NW59HJNcmmNnei6Ptajj+eZrteXyo9Y8FD3vBjsfKGz50ah4qtfc2ftQ2e/Hdp6xlIP9XYu3EvKYtUDAqBRtMC4ih9osno1Zp7gl+LyXPh8cqL4SX5priN4FpQ5era/88Lg8OJu7qF5dSx2Kt7Vm7BN9szFrHmlTMLCPA3HjveODY3f6jll3it2vH9gcm2h4nW03cxUwrzGdL6/q7ffBlPHeMnchtW1xNngvWKxF84nui50B0lwIm5v4frm6MXgSdl86v7TLhfq1NiTjtTzZMEcae/u77yUTq/sZu4MHjUrZzrkTnWeMG+eHBl/LKkROv65zs7eRIe9X92zppZCn3R+dkQ+5QvXi5pZpZ10UhKwzTy8xWLinHkneQy7euMvPGve7rgRnNTZ2BrtlY1EysWfPgjPJydXKh6Q2PHuzgv9fVVfrOAL9MzAkgm+8hfrTMcF/dLYMQ91T6e5g8/226haXCkmpIeCe9R1/ow56PmRCVOE7qE4NZgYnx2wAWpyKj+z8knu4VzwUdraexKd54Otc/LolW+PoTUWjH38gy+xPDLBS4ry8c0DFXvWPNT2wdTr3ure2eLataCZ2zr75fsheMf+4SAcc9kx6X79zgHQODa6tMCoMaDJ6tfY4mppSJ7/gj5wT/Dt8elQ8ZR25h9v63+ulsyTpT29tBxk3Nlb9ulZ3/dCNlN7SdPq1rw7nZZ/lO2UOrGH6fPxka4p/XQL980zbttlUxv27XIGraxdCxKntsaeeKSrq7bEqD8bVCz0nQy9PlvanZk0vfjCiKSVO/7srUn7S4KrknoSOif67lZeXVcsDkiESMXas1w2d46ZpLPX57WP6BVO+eXCgGw9mxh9tLvPGmu/XqgsWlWnxo66e+Hu9emUfS1Pb0bXlP1y7y4Utnw4Tl6XIDMnPvX2xOKS3WZrde2a3AD79d3YGr8sndo5cC+44/Jer8vXPshN8wEdV2PHry7Zq9m070+NmW8MfZRGxu39lW82c9YyOPFW587qbdZyldt8NylpbU/c5h6k5SPVaXEAfxwbXUF/maHGgKbao8bWN4d7zBkIaQV9gu+ey1RdmVSS5/LNmYfF8cl0/JRLt8f5nudisfOzM8HB+UK+62i997U2duaXSjO5wuh48rR8Cvte9vn4ucGUOSllDtOP2Zud39iZScnz9pGuO/7W7s7cqPtK5ZOP1LoKX29kz7K0XQ39ZqL02fP2NVZ3fHLNvyK2kDFnd6qvWNKTYSfis1vyn/Zjmm5Y174Zsn1j7M7cjOsjv58akwfE71aqrbFnzGMV7G5spS5JNXb7zyuRKilz+kb5ZFJ+eTOzuDY5PZe4KJkV9KX96vvbs14aOu9ugH1Mnu3uuzE3OpkdvT03dNU8quXTgZbW2JmBrItd+zElTJc/yeVumVJ7ceTabfNBhm/PDpgTXm3mQau9s3oX2jpHZoflM07ODSdHTGefS0tn5x/Onq5tQQB/NBtdWmDUGNBke9TYSjEhgRU8d4af7P17LWRnu07KU2Jo7JO3fdI1z53ZiXv5ocvm9a/TEjHhp2oh1TI5Yp6SwxOuMRsi9mB7vk0KYz10/kY/1O78HXMGq7rGwmd6dDF8pNZV+L3s9eAVVyDZW3I8OVGsc7wkhZZW5V3LL5qH6+il/PxqqEhWS+YclT29pEfqx+y4ubmvGgs/IJXq1Jj/YpW2xweO6Bm44GAbiLbG8oVCoid4QbY8QY1pU8aOX0qn7hZGkwlppWcumKTWs5g1U/041F7Fb+9j8B1lH+qaCb4Ja++sfehqJ7gS0dzfo9q+ABrIRpcWGDUGNFn9GsvlzAtAsZ7gCbimxvRVp1hn3+1CerGUeVQyL9u5mMgtzoWesNs6RkLXbjv6MuLJwaG7azOLm5nFJXPGZR81ljavi4VfH9zNTJqXsWpr7IlH1qkrez14xbmuleAFtZNjk67GTDm5423WBK9juuMtyQ55NJ7tH76Xjx+XaEibX1+QSJW8qTi/Fbo9tTW2sjYgNdyoGgt95HKNyU3qPSJf+o7r+cmHpZmlzfR4vPyIuZc47bT1pieCj6DnKU8lU7nSzGJZ5rE7B2Y9scYW7pnzc20Dc+bzlj/I5vyKe6UyfGe177sTGflWKR+febSdl/v7KNt1rD30VQbQGDa6tMCoMaDJ6tSY+b08KRl34XxtjVWfFloJnkH1KX93xjypn+mbKs4sbeXqXefkjil/Uns+6dNrbGN3Prj2v3yyzV2fVF1j0ltPOrJOjelZH7kNrh1tkga/naDHh/6m107avhKqF2BVsNfyH203p530AnM9V3cinnHdsLGVGpCjziSyO0EzydvdQ+5XBeUx7/xCk2tsuWAeVf+7rvL4XJW7qzWWy5oXE0+PLKUlksIxvRpUmr8ubS9PrDG9d+eDTvXvYtXeWflQQ8FDN1vnoQ5e7K68hQAawUaXFli4xqqOA9AIeon0CwPp4dvmCp7E5bh0gVkZdNdf19SYXYm1j4xmSzMPCvblSH3K15NSwa+/XUx0XRoZuJGdeOiu93ef1MZN26W5iYelmfvZPnsa5tNrzFyI1hOclovfLqQfrk2MB5cQ1amxJx9Zp8YkF8avmH5qH8xOPiyl783Fzd9fsOdd9Hhpgp4bS+mHpcnJpCm7Y3tcy2WvUpcJLryzi7kHs+bauGOJa5m1mYdrqWT/UXlUe+aC+Nux17S1XZqdeFCayeYT3cHvQja1xuyHjXUPTJvbM54yL0f6Glu4a84Uxtrj9v/QEB+ZTd3bDNp6NxP8ckPsxZGh6eLMYil9N3ttKDmUe4pzY/6hPn4xnbpvPvvEndmBwbT51Yd6d1Yfume7+26aB38muzScTA5MSebK1yW4es/9bgSAxtICo8aAJtMaq5j2ir/vVVtj5s9YXDfJ5eZMR+eJ2HPBU/5qafRqEGcVU3Nio7h2zQaHnZPxjpP7qjETRvfSHaHLjtpeNOFTW2NPPLJejYni2pC5kt3Pia6b9tSaq7E2W6p2Ogfu1jtbI9x1V+bqsfLZwd3M7JiNNJ1zY/pLhfIgLxfs37/QOdrZLnf5ZDNrTG7P9Ij7ux8yR9q7u5+xNVbaTt8cDN9VO+3271NsbE2mTEqGpjPxVDUm/1lcG75U8WDIHZwo7nVndzOZsdNf0APtdNyUu2B/V6PqcQbQMFpg1BjQbPniViZ8OU7VBUBiY3t+qfbCoN2FRfM/4U5l1jIru/nVrczSVm5d/7xW1w1zPZn9gOk7SXn6r/N8ubGduZ8fncyOZzcX1ndzy5uZgrkSyHzkR5szj9xfXhAl86uXmcKOTx+5zTPZpdTUUvrRTn5dbt6m/2MZVfY6Mr8i97ree5V25xeLqans6HRxpvxHTX29leYfrY1PZVN3zb0uv1c1+zpmnavL8yub6Yzc6/zEg9AdtOQByS7JA5K6XzIPyOPNjH0Qah+QKuEvUM0XSz5OxUvGq9uZpc2Mu+O5x2sTd7KjdwppeXjdq34L90yxHQ9f13V/rkfCzQZT8I754mb6rvnype6t+Y8WFnxe+cr6ld1cIbgl5Xsh92ttYjprHo2cO/IJd3bVfCnNL3LOFmcK7g6ulCbu5P0f6QXQWFpg1BhwmGxspYIL2P3Lc8JefWX/WphfPGz2OJe2l+VCn9zn9nK7HCq7GfOnN4K/N+EX5R6dlHs0ttf5OQCfSVpgXMUPHCYle04o9sy5kWs354Zvz10bsv+LpDP6x0IPq/3VWGlnZnpueDwd7zQvwnaal9JqjjkM9Ddej8X7UuaLOJxMdgZ/zaRD/4QsgM8+G11aYNQYcMisb03cCH530U1bT3I4u8f1VYfGPmtMf23T/NmIkcIhvpJJsnL2VsXfk2tPJKaq/t9WAD7LbHRpgVFjwGG1vr3XtVyH0Z7XmVXbzT3e6+96HEKlnYXl8uV6AD4/bHRpgVFjAAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDhGqs6DgAAAM2jBUaNAQAAtIQWGDUGAADQElpg1BgAAEBLaIFxFT8AAEDEbHRpgVFjAAAAEbPRpQVGjQEAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBUWMAAAARs9GlBRausarjAAAA0DxaYNQYAABAS2iBUWMAAAAtoQVGjQEAALSEFhhX8QMAAETMRpcWGDUGAAAQMRtdWmDUGAAAQMRsdGmBUWMAAAARs9GlBUaNAQAARMxGlxYYNQYAABAxG11aYOEaqzoOAAAAzaMFRo0BAAC0hBYYNQYAANASWmDUGAAAQEtogXEVPwAAQMRsdGmBUWMAAAARs9GlBUaNAQAARMxGlxYYNQYAABAxG11aYNQYAABAxGx0aYFRYwAAABGz0aUFFq6xquMAAADQPFpg1BgAAEBLaIFRYwAAAC2hBUaNAQAAtIQWGFfxAwAARMxGlxYYNQYAABAxG11aYNQYAABAxGx0aYFRYwAAABGz0aUFRo0BAABEzEaXFhg1BgAAEDEbXVpg4RqrOg4AAADNowVGjQEAALSEFhg1BgAA0BJaYNQYAABAS2iBcRU/AABAxGx0aYFRYwAAABGz0aUFRo0BAABEzEaXFhg1BgAAEDEbXVpg1BgAAEDEbHRpgVFjAAAAEbPRpQUWrrGq4wAAANA8WmDUGAAAQEtogVFjAAAALaEFRo0BAAC0hBYYV/EDAABEzEaXFhg1BgAAEDEbXVpg1BgAAEDEbHRpgVFjAAAAEbPRpQVWW2PhCb/blzq/rKtu8hu7fvf8V17SVTe51R2/2/1yr666yf79tt99+Wv9uurmvb/9d7/b239FV93c/cW/+N2+b7yqq27e/flv/O7AN4d11c1Mft3vfmPoTV11k/7gH/zu1ZExXXXzvfuP/e6rb97SVTe35v7G717/7pSuunn73Q/97sjb7+iqmxs//MDvjt6+q6tu3vr+e343NbWgq27euPUjvzs2/TNddTM8Pu13b2YWddXNUOp7fvf2/C901c3gGzf97vd/8ne66uaVb/+l373z01/pqpvLr77hd9/58J901U3/K9f97o8++lhX3fz516/53bnCv+qqm3jfZb97f/m3uuqmJ97nd99f+U9ddfOVl77qd3+2/t+66ubL57v97oel3+uqmy9+8Ut+V3ScO6cbbv76N//rdzv/9Lyuunnwj//jd7v+7GVddfPBr/7L77701Yu66mah+B9+98LFAV11c+/xv/ndr/3FVV118+NH/+x3LyWGdNXN7OKv/e7Xr31HV9388MGq373yrZSuupl6/5d+95vfeVtX3Uy+V/C7ryX/yi76mfjxkt/99o20rroZfyfvd1+/+a6uuvluOut3k5Pzuurmzcl5vytH6qob+Wh+Vz6LrrqRW+J35Rbqqhu5F3538r2CXfQjj4DfnXq/qKturnzrLb8rj6quupFH3u/KV0RX3chXze/KV1NX3chX3O/Kd4KuupHvFr8r30W66ualCxf9rnwH6qob+S71u/Ldq6tu5Dvc78p3vq66kX8dflfIvx3dcPOw9Hu/K//udNWN/Nv0u/JvVlfdyL9rvyv/3nXVjfxM8Lvys0JX3cjPE78rP2d01Y38LPK78jNKV93IzzG/Kz/fdNWN/Az0u/KzUVfdyM9Pvys/V3XVjfzs9bvyM1lX3cjPbb8rP8911c3Y9E/9rjwX6Kobeb7wu/I8oqtu5LnG78pzkK66kecpvyvPX7rqRp7j/K489+mqm1dHb/lded7UVTfy3Op35TlXV93I87LfledrXXUjz+l+V57rddWN9IDflU7QVTe9/Qm/K42hq26kQ/yu9ImuupGG8bvSNrrqRvrH70oX6aobaSe/K3Q1NFpg1Fh4qLHwUGPh+dzX2Fu66kaaw+8enBqTFb9LjVFjuuqGGgsPNRaeg1VjDMMwDMMwTPRDjTEMwzAMw7Ru/vCH/wPqoyQYexfR+wAAAABJRU5ErkJggg==",
	""
FROM "tbl_sheet" s 
LEFT JOIN "tbl_place" p 
    ON p.id = s.id_place 
LEFT JOIN "tbl_person" so 
    ON so.id = s.id_source_by 
LEFT JOIN "tbl_person" c 
    ON c.id = s.id_compiled_by 
LEFT JOIN "tbl_person" n 
    ON n.id = s.id_notation_by 
LEFT JOIN "tbl_type" t 
    ON t.id = s.id_type 
WHERE 
        p.txt_place = "Place 1" 
    AND 
		so.txt_person = "Person 1" 
    AND 
		c.txt_person = "Person 1" 
    AND 
		n.txt_person = "Person 1" 
    AND 
		t.txt_type = "Type 1"

This gives no error but doesn't insert record

2

You can't use cte like that. Select from it instead

WITH p AS (SELECT id FROM tbl_place WHERE txt_place = "Place 1")
INSERT INTO tbl_sheet(txt_rep_no, txt_song_name, id_place, id_source_by, id_compiled_by, id_notation_by, id_type, blob_sheet1)
select "1", "Song Name 1", p.id, 1, 1, 1, "", ""
from p

3

I have 3 different tables and foreing keys (tbl_place, tbl_person, tbl_type). Thanks for the reply anyway.

4

Below code only works if record already exits:

INSERT INTO "tbl_sheet" (
    txt_rep_no, 
    txt_song_name, 
    id_place, 
    id_source_by, 
    id_compiled_by, 
    id_notation_by, 
    id_type, 
    blob_sheet1,
	blob_sheet2
)
SELECT 
    "1", 
    "Yörü Bire Çiçek Dağı", 
    p.id, 
    so.id, 
    c.id, 
    n.id, 
    t.id, 
    "",
    ""
FROM "tbl_sheet" s 
LEFT JOIN "tbl_place" p 
    ON p.id = s.id_place 
LEFT JOIN "tbl_person" so 
    ON so.id = s.id_source_by 
LEFT JOIN "tbl_person" c 
    ON c.id = s.id_compiled_by 
LEFT JOIN "tbl_person" n 
    ON n.id = s.id_notation_by 
LEFT JOIN "tbl_type" t 
    ON t.id = s.id_type 
WHERE 
        p.txt_place = "Place 1" 
    AND 
		so.txt_person = "Person 1" 
    AND 
		c.txt_person = "Person 2" 
    AND 
		n.txt_person = "Person 2" 
    AND 
		t.txt_type = "Type 1"