>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