General information
Forum:
Microsoft SQL Server
Title:
Help to build a query
Environment versions
SQL Server:
SQL Server 2005
I have two tables (A and B) and in Table A there are to fields (IDRespG and IDRespP varchar(13) both) and in table B I have the IDUser (varchar(13)) and UserName
TABLE A:
IDRESPG IDRESPP
22222222 11111111
11111111 73161768
TABLE B:
IDUSER USERNAME
11111111 Peter G
22222222 Charles D
73161768 Vicky B
So, the output should be:
Charles D Peter G
Peter G Vicky B
How can I do this?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only