SQL For Experts

  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