Suppose two tables, Master and Detail.

Master structure:
masterId
masterFieldA

Detail structure:

detailId
masterId (to relate with Master table)
detailFieldA
detailFieldB

SQL Select statement would be:

Select M.*, D.* From Master M Inner Join Detail D ON D.masterId = M.masterId

Hope this helps. Good Luck! ;)