need help linking tables please

[ss7415]

i currently have

INNER JOIN qad_table ON CSD_TABLE.SUP_PART = QAD_TABLE.PART AND CSD_TABLE.SUP_PROJECT = QAD_TABLE.PROJECT

but if the qad_table.part is null , i want the first link to be

csd_table.sup_ord_nbr = qad_table.wo_nbr

thank you

 

[bborissov]

INNER JOIN qad_table ON
      (CSD_TABLE.SUP_PART = QAD_TABLE.PART OR
       csd_table.sup_ord_nbr = qad_table.wo_nbr) AND            
       CSD_TABLE.SUP_PROJECT = QAD_TABLE.PROJECT

not tested at all



Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ss7415]

i am getting alot of duplicats, i want to do the other link (csd_table.sup_ord_nbr = qad_table.wo_nbr) if part is null in the qad table. if it isnt then i want to do part on part

 

[ss7415]

actually i need to do more investigation