Forgive my ignorance, but I’m relatively novice when it comes to actually creating a BAQ from scratch. I have five tables, each a filtered set of parts from an external datasource. I’m creating a BAQ that can pull these tables into a single dataset. I assume that pulling five separate tables without…

In my experience you should be able to join multiple tables together in a BAQ. It would be helpful to know what your error is as well as what the joins look like that are causing long query times.

Part of the issue is that I want to join them all with an inner join but there’s “no top level query” when I have all my tables in a query and select “inner join” type.

If you’re novice, start small to get a grasp of the logic. A field needs to exist on each table otherwise you’re pulling all the data from each table and attaching it every result from the other table. Take Part and PartPlant, if you don’t join them, your results will show you every PartPlant reco…

The only “joins” I see are creating links on the rows of each table. If I do a join in a subquery it wants a top level query.

I think… if you’re pulling the same data (columns) from each source, you may be able to set each table up in its own union type subquery and see if you can pull them all together that way. This should union the results of each source into one final data set.

I get an error when attempting to do that: [image]

The column types must match. So for the first error, you need Part Number from both subqueries to both be nvarchar or both be varchar. What you might want to do is plan on them being nvarchar, and then if you bring a varchar field, use a calculated field of type nvarchar in your Display Columns, in…

BAQ with same columns from multiple tables

Kinetic ERP

Banderson (Brandon Anderson) May 6, 2025, 9:01pm 9

Check out the tools user guide on the help about BAQs. They have some good use cases to start learning BAQs. Also, check out this video I did. I think it will explain some things to you.

Topic		Replies	Views
Parts by customer - BAQ preferred Kinetic ERP baq	34	313	June 10, 2025
Adding a few tables to a BAQ / Bad SQL Statement Kinetic ERP baq , reports , dashboard	15	595	October 2, 2024
BAQ outer join problem? Epicor ERP 10	22	4993	April 6, 2022
BAQ: Questioning My Table Joins Kinetic ERP baq , kinetic	10	904	May 25, 2023
Can't get my BAQ to work properly Epicor ERP 10 baq	4	494	January 5, 2023

BAQ with same columns from multiple tables

Related topics