FULL JOIN

Question

Hi folk,I have table #1 with fields A,B,CAnd table #2 with fields D,E,FTables #1 and #2&nbsp;​​​are synchronized with QuickBooks.How can I have table #3 with all records and A,B,C,D,E,F fields from tables #1 and #2?​​​​------------------------------Andrew S------------------------------

markshnier__you · Answer

Can you explain how you would match up these records manually? How do you know which Table 1 Record match to Table2

Maybe you can give an example of the data so I can understand the matching you were looking for.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

markshnier__you · Answer

Is there a field known to both tables which is Unique?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

andrews · Answer

Nope------------------------------Andrew S------------------------------

andrews · Answer

Sure,Table Estimates has fields Product, Estimate Amount, Category (look up field from Category table)Table Purchase Orders has fields Product, PO Amount, Category (look up field from Category table)Table Categories has a field Category, and it is a Parent table for Estimates and Purchase Orders tables.I would like to have the Summary reports and the Chart reports, which will combine data from two and more tables, likeCategory 1 &nbsp;| sum of Estimate Amount &nbsp;| &nbsp;sum of PO AmountCategory 2 | sum of Estimate Amount &nbsp;| &nbsp;sum of PO Amount.....Category n | sum of Estimate Amount &nbsp;| sum of PO Amount------------------------------Andrew S------------------------------

markshnier__you · Answer

I think that all you need to do is to go to the relationship where One Category has Many Estimates and Create a Summary field there to total the Estimate value.The do the same on the other Relationship to&nbsp; Total the PO Amount.Then just add those two fields to the regular table report of Categories.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

FULL JOIN