Hello,
Trying to built a simple ACCPAC report which requires OPTIONAL FIELD TABLE VALUES to be JOINED to the MAIN select ......
I have this :
I would need to also ADD the
to the above COLUMNS returned.....
Can anyone help with this ?
Cheers,
Johnny
Trying to built a simple ACCPAC report which requires OPTIONAL FIELD TABLE VALUES to be JOINED to the MAIN select ......
I have this :
Code:
SELECT POPORH1.DATE, POPORH1.PONUMBER, POPORH1.VDNAME, POPORL.ITEMNO, POPORL.ITEMDESC, POPORH1.EXPARRIVAL AS PO_ETD, POPORL.EXPARRIVAL AS LINE_ETA, POPORL.OQORDERED, POPORL.OQRECEIVED, POPORL.OQOUTSTAND, ICITEMO.VALUE
FROM (POPORL INNER JOIN POPORH1 ON POPORL.PORHSEQ = POPORH1.PORHSEQ) INNER JOIN ICITEMO ON POPORL.ITEMNO = ICITEMO.ITEMNO
WHERE (((POPORH1.PONUMBER)="004061") AND ((POPORH1.ISCOMPLETE)=0) AND ((POPORL.COMPLETION)=1) AND ((ICITEMO.OPTFIELD)="4250"));
I would need to also ADD the
Code:
ICITEMO.OPTFIELD="4110"
Can anyone help with this ?
Cheers,
Johnny