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! ;)
Pablo Márcio de Oliveira
Inside the scream is silent, inside it must remain