Convert Oracle Select to SQL CE Select.

• gagan rastogi

  SSC Journeyman

  Points: 89

  More actions

  April 7, 2008 at 7:46 am

  #184264

  ORACLE:

  SELECT * FROM L_RPT_INV_PERSON_INFO WHERE (RPT_INV_ID,RPT_INV_TP) IN (SELECT RPT_INV_ID,RPT_INV_TP FROM L_RPT_INV_INFO where INFORMATION_CHANGED_FLAG='Y')

  What is the equivalent of above query for SQLCE.

  Urgent help Needed.

  Best Regards.

• Bob Fazio

  SSChampion

  Points: 10794

  More actions

  April 8, 2008 at 7:19 am

  #799714

  SELECT Person.* FROM L_RPT_INV_PERSON_INFO AS Person

  INNER JOIN L_RPT_INV_INFO AS Inv

  ON Person.RPT_INV_ID = Inv.RPT_INV_ID

  AND Person.RPT_INV_TP = Inv.RPT_INV_TP

  WHERE Inv.INFORMATION_CHANGED_FLAG='Y'

• Bob Fazio

  SSChampion

  Points: 10794

  More actions

  April 8, 2008 at 7:20 am

  #799715

  FYI, that is actually the correct way to write it in Oracle also

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  April 12, 2008 at 3:03 pm

  #801827

  An EXISTS might be a better choice depending on number of records.

  SELECTp.*

  FROML_RPT_INV_PERSON_INFO AS p

  WHEREEXISTS (SELECT * FROM L_RPT_INV_INFO AS i WHERE i.INFORMATION_CHANGED_FLAG = 'Y' AND i.RPT_INV_ID = p.RPT_INV_ID AND i.RPT_INV_TP = p.RPT_INV_TP)

  ---

  N 56°04'39.16"
  E 12°55'05.25"