Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: Retrieving data from multiple tables

    Hello,
    I am facing an issue here. In the attachment, there is a screenshot of an excel sheet. The blocks of data represent a table each. The coloured cells are the main columns from which data is to be retrieved.

    These are 5 tables named as stkin, stkout,issue, cons, intransit. Highlighted columns represent Store and its content quantity.

    I need a query to retrieve the quantity from a particular store. e.g for store 9779 there are two entries, namely StkInQty and TrOutQty

    What i wish is that by giving a query it should display something like the following:

    store StkInQty TrOutQty
    9779 1000 1000

    What i have shown is only 4 tables. But there are actually 9 tables and there are more than 15 stores, so doing it manually will take a lot of time.

    Plz help me with query..
    Attached Thumbnails Attached Thumbnails DB.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •