Posts by Tfmr_uk • 1 point

• 0

  votes

  1

  answer

  59

  views

  A: How to return empty value in column?

  I managed to solve, taking out WHERE A.PN IN ('RCF6709') and including it in LEFT JOIN as : LEFT JOIN ODB.PLANNING A ON A.AC = B.AC AND A.PN = 'RCF6709 SELECT B.AC, A.PN, COUNT (DISTINCT A.AC) AS…

  sql

  answered 5 years, 6 months ago Tfmr_uk 1

• 0

  votes

  1

  answer

  59

  views

  Q: How to return empty value in column?

  Basically the logic should be the following. Return the Acs (aircraft) that has the component RCF6709 installed (case 1) or not installed (case 0). See: Retrieve active aircraft on AC_Master;…

  sql

  asked 5 years, 6 months ago Tfmr_uk 1