UPDATE fish_species
SET fish_species.fish_specie_family_id = (SELECT fish_families.ID
FROM fish_families
WHERE is_family = 1)
WHERE fish_species.family IN (SELECT DISTINCT fish_families.science_name
FROM fish_families
WHERE fish_families.is_family = 1)

تم تعديل 13 مارس 201312 سنة بواسطة Ahmad.Hasan

السلام عليكم

SELECT fish_families.ID FROM fish_families WHERE is_family = 1

ELECT DISTINCT fish_families.science_name FROM fish_families WHERE fish_families.is_family = 1

عند تنفيذ الجملتين السابقتين كم عدد الصفوف المرتجعه ؟؟

return 43 row