Hi,
I am having two tables
One table: campid,primarykey ,surname varchar(),Givenname varchar(50)
second table: Rid int, campid,,surname varchar(),Givenname varchar(50)
how to retrieve these tables in a single row
like
in first table: campid,surname,givenname
1 xyz xyz
in first table: campid,surname,givenname
1 abc abc
2 asdf adf
i want to output like this
campid surname givenname
1 abc abc
1 xyz xyz
2 asdf adf
How to do this
Regards
Venkatesh