The latest articles on DEV Community by Akash Chawan (@akash_chawan). https://dev.to/akash_chawan https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1646669%2Fa6bc5815-a3df-4f00-934c-e47daa15bd18.png https://dev.to/akash_chawan en Akash Chawan Tue, 18 Jun 2024 16:19:57 +0000 https://dev.to/akash_chawan/how-to-join-tables-data-already-exist-in-table-2j80 https://dev.to/akash_chawan/how-to-join-tables-data-already-exist-in-table-2j80 <p>getting below error</p> <p>[Nest] 15320 - 18/06/2024, 9:48:15 pm ERROR [ExceptionHandler] Cannot add or update a child row: a foreign key constraint fails (<code>shipping</code>.<code>#sql-220c_403</code>, CONSTRAINT <code>FK_ce723b9c7f1fbc4a9a1cf4d8865</code> FOREIGN KEY (<code>present_rank</code>) REFERENCES <code>rank</code> (<code>id</code>) ON DELETE NO ACTION ON UPDATE NO ACTION)<br> QueryFailedError: Cannot add or update a child row: a foreign key constraint fails (<code>shipping</code>.<code>#sql-220c_403</code>, CONSTRAINT <code>FK_ce723b9c7f1fbc4a9a1cf4d8865</code> FOREIGN KEY (<code>present_rank</code>) REFERENCES <code>rank</code> (<code>id</code>) ON DELETE NO ACTION ON UPDATE NO ACTION)</p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>@Column() present_rank: string; @OneToOne(() =&gt; Rank,rank=&gt;rank.id) @JoinColumn({ name: 'present_rank' }) rank: Rank; </code></pre> </div>