extended query for work order traveller

Legacy Contributor

What I need to do is pull over a couple extra fields from the tables WORK ORDER and PART. the current extended query that I have is

SELECT WORK_ORDER.USER_7 , WORK_ORDER.USER_8 , WORK_ORDER.ORIG_STAGE_REVISION_ID , PART.ENGINEERING_MSTR , PART.STAGE_ID , PART.REVISION_ID , PART.PRIMARY_LOC_ID FROM WORK_ORDER , PART WHERE WORK_ORDER.BASE_ID = :WO_BASE_ID AND WORK_ORDER.LOT_ID = :WO_LOT_ID AND WORK_ORDER.SPLIT_ID = :WO_SPLIT_ID AND WORK_ORDER.SUB_ID = '0' and PART.ID = :WO_PART_ID

What I am finding is that when it prints the pages for a leg it takes all the variables WO_BASE_ID, WO_LOT_ID, WO_SPLIT_ID and the one that is messing up the report is the WO_PART_ID from the leg header card. For all the operations and parts that are attached to the SUB_ID = 0 everything works fine. When it prints the leg info, it pulls the part number off the leg which is null. This makes all the fields blank. I have also tried WORK_ORDER.PART_ID with the same result.
I was looking at doing a join of the PART table just to keep the WORK_ORDER info, but read in one of the knowledge base articles that the extended queries do not support the "join" function and you are supposed to use the "+" operator. I can't find anything that explains how to use this operator. Any help is greatly appreciated

Thanks
Joel