Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query -SQL

Status
Not open for further replies.

PatelRam

Programmer
Aug 20, 2003
87
US
Hello,

I have a table which contains following data.

TableA:

ColumnA ColumnB

A1 C1
A1 C2
A2 C3
A2 C4


I need to build query which give me follwing output :

A1 C1:C2
A2 C3:C4

Can someone help me out.

Thanks,

Ram
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top