hi,

i'm attempting to join 2 fairly large tables (200,000 recs each) on multiple fields via:

select b.* from detail d join barcodes b on d.po_num = b.po_num and d.style = b.style where d.wo_num = 123456 into cursor csrBcodes

d.wo_num, d.po_num, d.style, b.po_num & b.style are all indexed, yet this query takes more than 30 secs. if i limit the join condition to a single field - either po_num OR style - the query runs in less than a second??!

any thoughts? are multiple condition joins just slow??

thanks in advance.