use Join
select tbl1.fld1 as t1_fld1,tbl1.fld2 as t1_fld2
,tbl2.fld1 as t2_fld1 ,tbl2.fld2 as t2_fld2
from
tbl1
inner join tbl2 on tbl1.fld1=tbl2.fld1
tbl1
-------------
fld1 fld2
-------------
a b
1 2
tbl2
-------------
fld1 fld2
-------------
a c
1 3
Result
---------------------------------------
t1_fld1 t1_fld2 t2_fld1 t2_fld2
---------------------------------------
a b a c
1 2 1 3
two different tables rows are merged into single row using join
this way first & second tables' related rows will be shown as
single row in resultant table-set.
if you ask your question with example, then it will be more easy to understand.
Happy Coding!
:)