Bruno Casado
10/27/2021, 6:08 PMselect gene_1_id , wi.genotype_emedgene_1, wi.genotype_emedgene_2, genotype_1, genotype_2 from womancare_info wi
where
(
wi.genotype_emedgene_1 in (select genotype from gene_genotype gg where wi.localization_1 = gg.localization)
and
wi.genotype_emedgene_2 in (select genotype from gene_genotype gg where wi.localization_2 = gg.localization)
)
or
(
wi.genotype_emedgene_1 in (select genotype from gene_genotype gg where wi.localization_1 = gg.localization) and wi.genotype_emedgene_2 = ''
);
where:
wi.genotype_emedgene_1 in (select genotype from gene_genotype gg where wi.localization_1 = gg.localization)
How do i perform this kind of query using prisma? Filtering by using a parent field on subquery?