>I have three tables Invoice, Invoice-detail, Customer, how can i use the SELECT command to join this tables.
>The command key of Invoice and Invoice-detail is Inv-No.
>The command key of Invoice and Customer is Cust-No.
>
>I waiting for any suggestions ?
>
>Thanks
>
>Dennis

select * from customer ;
   inner join invoice ;
   inner join invoice-detail ;
     on invoice.inv_no = invoice-detail.inv_no ;
     on customer.cust_no = invoice.cust_no

Cetin