When your day-to-day tasks scope consists of lots of document editing, you know that every file format needs its own approach and sometimes specific applications. Handling a seemingly simple ps file can often grind the whole process to a halt, especially when you are attempting to edit with insufficient software. To avoid this kind of difficulties, get an editor that will cover all your requirements regardless of the file extension and join table in ps without roadblocks.
With DocHub, you will work with an editing multitool for just about any occasion or file type. Reduce the time you used to devote to navigating your old software’s functionality and learn from our intuitive user interface while you do the work. DocHub is a efficient online editing platform that covers all your file processing requirements for any file, including ps. Open it and go straight to efficiency; no previous training or reading manuals is required to reap the benefits DocHub brings to papers management processing. Start with taking a couple of minutes to create your account now.
See upgrades within your papers processing immediately after you open your DocHub account. Save time on editing with our one solution that can help you become more efficient with any document format with which you need to work.
hello friends in this video we will learn how to join two tables in a PS query lets go to reporting tools query query manager create a new query select any tables say ledger had record say in the first stage we want to select business unit account fiscal year and posted total amount we want to further filter for you business unit us 0 0 1 all the accounts and fiscal year say 2013 we want aggregate amount so we need to go to fields click on edit for posted total amount and select some click OK we can see that sum is written under aggregation for posted total amount try to run the process so these are the balances for 2013 for business community us 0 0 1 for various accounts now as the second part of the requirement we want to show account type also for all the accounts shown in the PS query for that we need to join a needle table with the existing query that is having account type as a field go to the now we know that GL account TBL is the table that we need to join when we click join