dcsimg
Results 1 to 2 of 2

Thread: Query dependancy

  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Query dependancy

    Hi,

    I am trying to solve a SQL query and am looking for some help on how to do this.

    The scenario is : I need to look at travel agents and the payments that they have taken within a certain time period.My first query should identify the payments taken for the branch which i can do.

    My second query should return the travel agents names against the payments taken. I am not sure how to do this in by using query 1.

    I was thinking of using a #table for the query and then return seperate datasets?.The first dataset would be the Travel agent summaries,the second dataset would be the Travel agent payments taken.


    Is this the best option or is there a better way of doing this?.

    Thanks

    J

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,912
    Can't you join the two tables to get travel agent name in one query?. It is hard to make a suggestion without knowing the table structures.

Posting Permissions

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