Select First value from Detail table

Hi All,

          I am working on CustomerMaster & CustomerDetail tables. In Detail table, there are many records for one customerID and CustomerID is the PK in Master table . I want to create a SQL statement which should include all the records from Master Table and first matching record from the Detail Table.
How do we write a SQL sttement.?
Any help on this problem is appreciated.

Thanks in advance.
SMV



smv939Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
select *
from master m
join detail d
 on d.master_key = m.key
where d.somefield = ( select top 1 i.somefield from detail i where i.master_key = m.key )
0
 
smv939Author Commented:
Thanks so much. It worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.