Hi,

I need some help with SQL to do the following:

Table1

1 John Smith
2 Jess Green

Table2

1 One
1 Two
2 Three
2 Four


What I need is a SQL statement which will give me the following.

John Smith One, Two
Jess Green Three, Four


Is this possible with just SQL Syntax?



Thanks in advance.