Good Afternoon
I'm having an issue getting my head around a select statement using multiple joins! I've built my query in stages and tested as I've gone and it works fine until the third / fourth join is created so I need some advice!
I have and POP_Header table, an POP_Detail table, a PL_Accounts table and a STK_Stock table
The POP_Header contains a field SUCODE which links to the POH_Account field on PL_Accounts.
The POP_Header contains a field POH_Reference which links to the POD_Reference field on POP_Detail.
The POP_Detail contains a field POD_Stock_Code which links to the STKCODE field on STK_Stock.
The select should return one line per record on the POP_Detail table
Please can someone advise what the Select statement should look like?
Many thanks
Steve
I'm having an issue getting my head around a select statement using multiple joins! I've built my query in stages and tested as I've gone and it works fine until the third / fourth join is created so I need some advice!
I have and POP_Header table, an POP_Detail table, a PL_Accounts table and a STK_Stock table
The POP_Header contains a field SUCODE which links to the POH_Account field on PL_Accounts.
The POP_Header contains a field POH_Reference which links to the POD_Reference field on POP_Detail.
The POP_Detail contains a field POD_Stock_Code which links to the STKCODE field on STK_Stock.
The select should return one line per record on the POP_Detail table
Please can someone advise what the Select statement should look like?
Many thanks
Steve