Help with a query or a report

  • Thread starter Thread starter Serg Matvienko
  • Start date Start date
S

Serg Matvienko

Hi everybody,



In short, there are 3 tables - A, B, C for example. The table A has 2
fields - PersonCode, PersonName. The table B has PersoneCode, LanguageCode
and the table C - LunguageCode, LanguageName. The table A is a master table,
the table B is a detail table because every person can speak several
languages. I need a report or a query where every person has only 1 row,
and this row contains only 2 columns - a name of person and a list of
language names separated with commas. Please help to make the query .



Thank in advance,



Serg
 
At least one reply to this same question posted in another NG. Please limit
your questions to a single NG.
 
Hi Duane,

Thank you a lot for the nice link you sent me. You helped me very much. I'm
sorry, but I posted my question in two NG only because i was not sure that
it is possible to crack this problem using only SQL query.

Sincerely,
Serg
 
Back
Top