how copy acolumn by a query.

See more:

SQL-server-2000

SQL-Server

In my application

I used a query ,returns 14 rows.

I need to add a column to this result ( from a other teble).

I got by use of inner join but it returns more than 14 rows.

I just need to display a 'date ' in 14 rows ,the date is same for 14 rows.
The added column tacble containd a reference field.
query as below

SELECT distinct  '99991', tbl_DisclosureTypeDetails.disclodetDisclosureId,isnull( tbl_Disclosures.Disclosures,'') AS Expr1
FROM         tbl_DisclosureTypeDetails INNER JOIN
                      tbl_Disclosures ON tbl_DisclosureTypeDetails.disclodetDisclosureId = tbl_Disclosures.DiscId
WHERE     (tbl_DisclosureTypeDetails.disclodetMasterId = (SELECT     BMDisclosure
                            FROM          tbl_BorrowersMaster
                            WHERE      BMId =    223)) and tbl_DisclosureTypeDetails.disclodetDisclosureId  NOT IN(SELECT     BMCDisclosures
FROM         tbl_BorrowersMasterChild
WHERE     (BMCBorrowerID =    223))