BAQ Inner/Left Join Question E10.0.700.4

Try MiscChrg Criteria:  TaxCat = Freight or ? (Unknown) 

I’m on version 9 progress so I don’t know your syntax exactly.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, January 20, 2016 12:06
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Inner/Left Join Question E10.0.700.4

 

 

Hi,

I have the following BAQ:

1. Erp.InvcHead ------ Inner Join ------ 2.  Erp.CashDtl (criteria - Type = PayInv)

     |       |

     |       |

     |           ---------- Left Join -------- 6. Erp.InvcMisc ------- Inner Join ------- 7. Erp.MiscChrg (criteria - TaxCat = Freight)

     |

     |

        ------------ Inner Join ----------  3. Erp.OrderHed ------- Inner Join --------- 4. Erp.Customer

                      & nbsp;                                         |

                                                                |

                                                                   ----------  Inner Join ---------- 5. Erp.ShipTo

I want all invoices,so I do a Left Join between table 1 and 6.

I want only Misc Charges with a Tax Category of Freight from table 7 (we didn't have have this set for a lot of our history), so I do an Inner Join between table 6 and 7.

When I set the Inner Join between 6 and 7, I get only Invoices from 1 where I get results from 6 and 7. No rows where there is no Misc Charge with Freight.

I thought I would get all invoices, with Misc Charges matching matching Freight, if any.

Wonder where I'm going wrong?

Thanks,

Joe

--

Joe D. Trent

Bigham Ag Equipment

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  

Hi,

I have the following BAQ:

1. Erp.InvcHead ------ Inner Join ------ 2.  Erp.CashDtl (criteria - Type = PayInv)

     |       |

     |       |

     |           ---------- Left Join -------- 6. Erp.InvcMisc ------- Inner Join ------- 7. Erp.MiscChrg (criteria - TaxCat = Freight)

     |

     |

        ------------ Inner Join ----------  3. Erp.OrderHed ------- Inner Join --------- 4. Erp.Customer

                                                                |

                                                                |

                                                                   ----------  Inner Join ---------- 5. Erp.ShipTo

I want all invoices,so I do a Left Join between table 1 and 6.

I want only Misc Charges with a Tax Category of Freight from table 7 (we didn't have have this set for a lot of our history), so I do an Inner Join between table 6 and 7.

When I set the Inner Join between 6 and 7, I get only Invoices from 1 where I get results from 6 and 7. No rows where there is no Misc Charge with Freight.

I thought I would get all invoices, with Misc Charges matching matching Freight, if any.

Wonder where I'm going wrong?

Thanks,

Joe

--

Joe D. Trent

Bigham Ag Equipment