Combining two tables into one

[deante]

I have two data tables, like the ones below.

Group 1
USER ID FIRST NAME LAST NAME
AAA0QTB AARON ADAMS
AAA0QTB ALEX ABRAMS
AAC0P7Y ADAM CARTER



Group 2

GPMEM_NAME GPMEM_MEMBER_ID USBD_PROGRAMMER
GROUP02B AAA0QTB GONZALEZ, ALEJANDRO
GROUP02B AAA0QTB ALI, ADYA
GROUP02B AAC0P7Y CATANO, ANDRES A

I want to run a query with a result like this one

Wanted query

USER ID FIRST NAME LAST NAME USBD_PROGRAMMER
AAA0QTB AARON ADAMS GONZALEZ,ALEJANDRO
AAA0QTB ALEX ABRAMS ALI, ADYA
AAC0P7Y ADAM CARTER CATANO, ANDRES


I BASICALLY WANT TO GROUP FIELDS FROM TWO DIFFERENT TABLES ACCORDING TO USER ID.I HOPE SOMEONE CAN HELP ME. THANKS IN ADVANCE

 

[fredericofonseca]

search these forums for "select" and "Inner join" and you will find plenty of examples

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[PHV]

Provided the RelationShips are properly set, the query wizard should automagically join the 2 tables ...

 

[worldwise]

Try:

SELECT table1.userID, table1.firstName, table1.lastName, table2.USBD_PROGRAMMER FROM table1 LEFT JOIN table2 ON
table1.userID = table2.GPMEM_MEMBER_ID

**Change the table names and field names to match your own.