Forum Discussion

Qrew Trainee

4 years ago

FULL JOIN 2

My firs topic wasn't resolved, so will try to provide more info about my Tables and Relationships: 'Budgets' has many 'Budget lines' (connected thru 'Estimate' field) 'Estimates' has many 'Budgets...

Relationships

reports and charts

AndrewS

Qrew Trainee

Thanks for the Reply Mike,
but my child tables don't have equal ID's, actually this is a reason, why I try to use FULL JOIN.

In the SQL full join means

table 1 fields A B C

table 2 fields D E F

FULL JOIN TABLE 3 WILL HAVE FIELDS A B C D E F

------------------------------
Andrew S
------------------------------

BlakeHarrison

Qrew Captain

4 years ago

In Quickbase, reports are generated on a single table, though you can use the API to query different tables and combine that information into a single report using a Code Page. For a standard report in Quickbase, you will have to create a 3rd table where you can aggregate those records.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------

BlakeHarrison
Qrew Captain
4 years ago
Re-reading your post, if you want to see your data separated by Category, you should be able to do this with your existing structure. Using Summary fields between your Categories table and the PO Lines and Estimate Lines tables, you can summarize the information you would like to see on your report. You would then build the report on the Categories table.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------