SQL query problem

[Omavlana]

Hi, I hv the following query that is returning correct values.
However, I want to add one more condition to this query.

select b.btdnumber as btdnumber,
b.btdtrfno as bbtdtrfno,
a.btdtrfno as btdtrfnohidden,
a.BtdAcno as BtdAcno,
a.BtdCertNo as BtdCertNo,
a.BtdShare as BtdShare
from shrbatchdetail a
right outer join shrbatchdetail b
on a.btdrecid = b.btdrecid
and a.btdsellbuy = 'S'

Along with the above details and satisfying above conditions, I want
to get

c.shmName from shrShareMaster c where c.shmacno = b.btdacno

Pls help me to modify the query.

-Omav

[Anith Sen]

Always post table DDLs, sample data & expected results for such
requirements. Here is my guess:

SELECT b.btdnumber AS btdnumber,
b.btdtrfno AS bbtdtrfno,
a.btdtrfno AS btdtrfnohidden,
a.BtdAcno AS BtdAcno,
a.BtdCertNo AS BtdCertNo,
a.BtdShare AS BtdShare,
c.shmName
FROM shrbatchdetail a
RIGHT OUTER JOIN shrbatchdetail b
ON a.btdrecid = b.btdrecid
AND a.btdsellbuy = 'S'
INNER JOIN shrShareMaster c
ON c.shmacno = b.btdacno ;

--
--- Anith