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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.