Kelloggs
Active Member
Do crazy people know they are crazy?
Posts: 785
Gender:
|
I dont understand what information you are trying to get, but I am going to take a wild guess: A way to link it would be using tables: BKARCUST, BKARHINV, and BKARINVL Example: SELECT DISTINCT BKARCUST.BKAR_CUSTNAME, BKARHINV.BKAR_INV_NUM, BKARHINV.BKAR_INV_SONUM, BKARHIVL.BKAR_INVL_CNTR, BKARHIVL.BKAR_INVL_PCODE, BKARHIVL.BKAR_INVL_PQTY FROM BKARCUST INNER JOIN (BKARHINV INNER JOIN BKARHIVL ON BKARHINV.BKAR_INV_NUM = BKARHIVL.BKAR_INVL_INVNM) ON BKARCUST.BKAR_CUSTCODE = BKARHINV.BKAR_INV_CUSCOD; Depending on the size of your DB, I would recoment you to use a pass-through query, to select the columns and data that you need before doing the link. Regards, Kelloggs
|