April 7, 2008 at 7:46 am
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.
April 8, 2008 at 7:19 am
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'
April 8, 2008 at 7:20 am
FYI, that is actually the correct way to write it in Oracle also
April 12, 2008 at 3:03 pm
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"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy