SQL doubt

[bevarse]

12 minutes ago, khabardar said:

Select O.orderID ,O.ItemId, O.OrderDate,S.Status

FROM dbo.Orderr O 

JOIN dbo.Status S  ON O.orderid = S.orderid

where O.orderID not in ( select OrderId from  Status where Status = 'Delivered')
 

-- I tested bro.. edi pakka pani chestadi.. chudu.. 100% sure

yaay idi kuda work ayyindi thanks again bhayya 

[bevarse]

10 minutes ago, Suhaas said:

daily work activity yenti - AFDB 

how come you are so smart ? - Naak antha scene ledu bro. 

 

7 minutes ago, BostonBullodu said:

braboyii eh chinna query ke antha happy ayyava way to go brother now you will understand diff between in and not exists especially if there are nulls check it out.... 

yedo bro meeku chinna gane vuntundi yemo 

nenu deenimeeda oka 2 hrs time waste chesa thokkalodi NOT EXISTS and NOT IN yenduku idea raaledo 

anyway now ee query ni linq/EF ki marchali 

[Suhaas]

7 minutes ago, bevarse said:

 

yedo bro meeku chinna gane vuntundi yemo 

nenu deenimeeda oka 2 hrs time waste chesa thokkalodi NOT EXISTS and NOT IN yenduku idea raaledo 

anyway now ee query ni linq/EF ki marchali 

Linq: 

from O in db.Orders
where
      (from S in db.Status
    where
      O.OrderId == S.OrderId &&
      S.Status1 == "delivered"
    select new {
      S.OrderId
    }).Single() == null
select new {
  O.OrderId
}

[IMP]

10 minutes ago, bevarse said:

 

yedo bro meeku chinna gane vuntundi yemo 

nenu deenimeeda oka 2 hrs time waste chesa thokkalodi NOT EXISTS and NOT IN yenduku idea raaledo 

anyway now ee query ni linq/EF ki marchali