SQL For Experts

Hi Everyone,

  Do you know How I could get a Table That would do This:

Select Client.NAME, Invoice.DATE, Invoice.AMMOUNT   From CLIENT Client, INVOICE Invoice
  WHERE Client.CLIENTID = Invoice.CLIENTID     AND CLIENTID = 1 Result

NAME DATE AMOUNT

BOB        2/1/1998        10.00
BOB        2/2/1998        10.00
BOB        2/3/1998        10.00
BOB        12/12/1998   10.00

And How Could I turn it into a result Like This

BOB    2/1/1998        10.00       2/2/1998        10.00      2/3/1998
10.00     12/12/1998   10.00