Selecting details on inner query

[ganeshmoorthy]

where is the link or which field will be used to link the master and details table....anyway using this query you can get some idea...

SELECT Master.code AS MasterCode, Master.Description AS MasterDescription, Detail.AnotherDescription AS DetailDescription
FROM Master INNER JOIN Details ON Master.Code = Detail.Code