Are these SQL statements equivalent?

From: deanbrown3d <deanbrown3d_at_yahoo.com>
Date: 24 Jun 2005 07:21:43 -0700
Message-ID: <1119622903.809392.165680@z14g2000cwz.googlegroups.com>

If I have a SQL statement:

---

update TRAIN_ROUTE_MQ TRMQ
set (TRAIN_I, P_VERSION_I) =
(
  select TRAIN_I, P_VERSION_I
  from TRAIN_MQ MQ
  where MQ.TRAIN_IMP_I = TRMQ.TRAIN_IMP_I   and MQ.LOCKED_PROJECT_I = " + XXXXXXXXXXXXXX )
where TRMQ.LOCKED_PROJECT_I = iCurrentProject;

---

Is there any difference between setting the XXXXXXXXXXXXXX to:

iCurrentProject

or

TRMQ.LOCKED_PROJECT_I Thanks for any info,

Dean Received on Fri Jun 24 2005 - 09:21:43 CDT