+ Reply to Thread
Results 1 to 2 of 2

How to pull data from two tables

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    How to pull data from two tables

    Hi Everyone,

    I am relatively new in SQL / Access Programming. We have a training at the office for simple query like Select * from and found this skill useful for my work...

    I have access in my SQL server now, can pull simple data but now, I am trying extract data in two tables:

    First table Name: Customer_DB

    Columns Available - Customer ID, Name, Address, Age, Total Payment

    2nd table: Agent_DB

    Columns Available - Agent Name, Agent ID, Customer ID, Agent Total Sales

    My question, how do i make this work? Based on the Customer ID in Customer DB, I need to extract the Agents that is handling the customer account. Customer can have multiple agents...

    Hope someone can help...

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: How to pull data from two tables

    Adapt this to your needs

    Please Login or Register  to view this content.
    Last edited by Bob Phillips; 08-04-2020 at 07:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to pull in data to the right of certain sheet's tables using VBA.
    By beaglesBuddy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2017, 01:13 PM
  2. Pull spefic data, sort & average it and put into seperate tables
    By antmcg12 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-06-2014, 01:18 PM
  3. Replies: 9
    Last Post: 03-19-2012, 02:36 PM
  4. Any definitive way to pull tables into word with xml?
    By bruceschaller in forum Access Tables & Databases
    Replies: 0
    Last Post: 04-11-2011, 04:10 PM
  5. Excel Tables - Formulas to pull data from
    By Hans of CO in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2009, 07:30 PM
  6. Pull Down boxes and Tables
    By Audiguy82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2007, 02:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1