data from tables not likned

Hi ;
Can some please tell me how to retrieve data from a table which is not linked For example i want total sale for aperiod to get the sale percentage of respective departments with respect to total sale or is there a way to call a sectionHow did the tables relate to each other? If you are not able to join, make use of sqlquery property and write that as sub query