hey guys

i have the following problem:

table 1(movie) contains:
movieID movie
---------------------------
00128 bad boys

table2(actor)
actorID actor
------------------------------------
004 will smith
005 martin lawrence

table3(actorConnect)
acConID movieID actorID
------------------------------------
0011 00128 004
0012 00128 005


how do i code, if i want the following output:

movie actor actor
--------------------------------------------------
bad boys will smith martin lawrence

thanks in advance

presumably you know how to join the tables to get this result, yes?

movie actor
bad boys will smith
bad boys martin lawrence

"flattening" (or denormalizing) the result set is purely cosmetic, and is best done by your scripting language

there is no simple sql that will do it for you, except in sybase ase (LIST) or mysql version 4.1 (GROUP_CONCAT)

ok, thanks

i will try