Professional Web Applications Themes

Select Sum acrross tables - MySQL

Hi, I have few different sales tables and I would like to know how I can write qeury that produces following results.. Tables=(sale.accom, sale.meals, sale.other) A M O (accom total, meals total, other total) ____________________ Client1 10 0 20 Client2 20 0 126 Client1 0 232 34...

  1. #1

    Default Select Sum acrross tables

    Hi,

    I have few different sales tables and I would like to know how I can write
    qeury that produces following results..

    Tables=(sale.accom, sale.meals, sale.other)

    A M O (accom total, meals total, other total)
    ____________________
    Client1 10 0 20
    Client2 20 0 126
    Client1 0 232 34


    Jared Guest

  2. #2

    Default Re: Select Sum acrross tables

    Jared wrote:
    > Hi,
    >
    > I have few different sales tables and I would like to know how I can write
    > qeury that produces following results..
    >
    > Tables=(sale.accom, sale.meals, sale.other)
    >
    > A M O (accom total, meals total, other total)
    > ____________________
    > Client1 10 0 20
    > Client2 20 0 126
    > Client1 0 232 34
    >
    >
    It would help if we knew the schema of your tables.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

Similar Threads

  1. Select accoss 2 tables
    By ShowOffs.ca in forum PHP Development
    Replies: 0
    Last Post: June 11th, 07:32 PM
  2. Select from two tables
    By Taper Litwater in forum ASP
    Replies: 4
    Last Post: October 27th, 08:41 PM
  3. MySQL Q - SELECT with 2 tables
    By Geoff Berrow in forum PHP Development
    Replies: 4
    Last Post: September 5th, 07:17 AM
  4. SELECT DISTINCT from two tables
    By Marco Alting in forum ASP
    Replies: 4
    Last Post: July 31st, 10:26 AM
  5. Select quantity from 2 tables
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 10
    Last Post: July 8th, 03:01 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139