Re: SQL query problem - 10-11-2003 , 08:43 AM
It is alot easier if you post the DDL (Create table statements) Example data
(as insert statements) as well as your query
and expected results.
As you already have a join then I am not sure why you have problems joining
the extra table. What errors are you getting.?
A guess would be:
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 as shmName
FROM shrbatchdetail a
RIGHT OUTER join shrbatchdetail b on a.btdrecid = b.btdrecid and
a.btdsellbuy = 'S'
JOIN shrShareMaster c ON c.shmacno = b.btdacno
"Omavlana" <kiran (AT) boardroomlimited (DOT) com> wrote