select a.invoiceid,a.description,a.amount,a.dateentered,a.payed,c.name,c.emailaddress,
    c.streetaddress,c.city,c.state,c.zip,c.phonenumber 
  from invoices a,customers c where a.cid=c.cid and a.cid="30"