Hello guys i'm here again asking for help: I need...
# orm-help
b
Hello guys i'm here again asking for help: I need perform the following query:
Copy code
select 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:
Copy code
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?