Adapter
llblgen Pro V2.5
C#.net 2005
Oracle 10g, SqlServer 2000, MySql 5.0
I try to write a query like;
select * from siparis_kalemi s where not exists
(select * from acilan_is_emri
where acilan_is_emri.musteri_siparis_no = s.SIPARIS_NO
and acilan_is_emri.MUSTERI_SK_NO = s.SK_NO )
and s.SK_DURUMU = 2
I tried this but i could not find joining the tables over two fields.
filter2.Add(new FieldCompareSetPredicate(
SiparisKalemiFields.SkNo, null, AcilanIsEmriFields.MusteriSkNo, null,
SetOperator.In, (AcilanIsEmriFields.MusteriSiparisNo == SiparisKalemiFields.SiparisNo) &
(AcilanIsEmriFields.MusteriSkNo == SiparisKalemiFields.SkNo) &
(AcilanIsEmriFields.IsEmriNo == UretimIsEmriFields.IsEmriNo) &
(SiparisKalemiFields.SkDurumu == (decimal)2)
, true));