Re: select from a join (a better/Quicker way??)

add buyer_name index for each table. Simon Buchanan wrote: Huston we have a problem: table1: purchase_order (primary key) client_number buyer_name table2: client_number buyer_number buyer_name (all three combine for the primary key for table2) Query: select

select from a join (a better/Quicker way??)

Huston we have a problem: table1: purchase_order (primary key) client_number buyer_name table2: client_number buyer_number buyer_name (all three combine for the primary key for table2) Query: select table1.purchase_order, table1.buyer_name, table2.buyer_number from table1 inner join table1