Yuridik shaxs jadvali bilan shartnoma jadvalini qanday birlashtirish mumkin? Yuridik shaxs bo'yicha shartnomalarni qanday tanlash mumkin?

Yuridik shaxslar jadvalini shartnomalar jadvali bilan birlashtirish uchun odatda SQL JOIN dan foydalaniladi, bu yerda shartnomani yuridik shaxs bilan bog'laydigan asosiy maydon, masalan, legal_entity_id.

So'rov misoli:

SELECT contracts.*
FROM contracts
JOIN legal_entities ON contracts.legal_entity_id = legal_entities.id
WHERE legal_entities.id = :legal_entity_id;

Shunday qilib, ma'lum bir yuridik shaxsga tegishli barcha shartnomalarni INNER JOIN yoki LEFT JOIN yordamida tanlash mumkin, vazifaga qarab.