HI All,

I have a table with 4 columns like name, primary acct.no, secondary acct.no and branch name. I need to select the record only when the primary acct.no and secondary acct.no is different. kindly help me on this select query.

table structure

Name PAcctNo SAcctNo Branch
ABC 0001 0001 DEF
ABD 0002 0003 ERF
DER 0004 0005 RET

I have to write a query such that i have to select only the second row.Kindly help me on this query.

Thanks in Advance,
Arul.

SELECT * FROM myTable WHERE PAcctNo <> SAcctNo;

--

Joe (Microsoft MVP - XML)

Hi Joe,

Thanks for the reply... but i read in some forums that '<>' operator is not advisable that's why i posted. your an Microsoft MVP can u please comment on the same.

Thanks,
Arul.