Viewing 4 posts - 1 through 5 (of 5 total)
MIT (2/27/2008)
from T1...)
You don't need to select the SALEID in an exists
EXISTS(SELECT 1 FROM T1...) instead.
from...
February 27, 2008 at 12:46 pm
exists(select saleid
from T1...)
You don't need to select the SALEID in an exists
EXISTS(SELECT 1 FROM T1...) instead.
from T1...
February 27, 2008 at 12:44 pm
John Rowan (2/22/2008)
February 23, 2008 at 7:02 pm
Ok ...
I should tell you in detail now
I have a table say Table1 ....
it has columns ... saleid,clientid,merchantid,affiliateid,salestatus,firsttransaction...
saleid is unique...
any sale that is made... is assigned a saleid......
February 22, 2008 at 2:27 pm
Viewing 4 posts - 1 through 5 (of 5 total)