Query Required
Posted: Sat Oct 30, 2010 3:08 am
i require query for following scenario
I have two table
table1 have following columns
person_id
Name
gender
and has 1 record
person_id Name gender
1 Robert Male
and table2 has following column
person_id
result1
and has following 3 rows
person_id result
1 php1
1 php2
1 php3
I need query for displaying result like this
Robert male php1 php2 php3
I have two table
table1 have following columns
person_id
Name
gender
and has 1 record
person_id Name gender
1 Robert Male
and table2 has following column
person_id
result1
and has following 3 rows
person_id result
1 php1
1 php2
1 php3
I need query for displaying result like this
Robert male php1 php2 php3