Professional Web Applications Themes

travial querry - why this doesnt work (MsSQL user:) ) - MySQL

helo! i work as MSSql admin, soo i believe thats trivial problem. i have querry, which doesnt work in MYSQL, pleae help: --- START --- select * from ( (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '1' and `data_off` > '1172729640' group by `dzial`) union all (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '2' and `data_off` > '1172729640' group by `dzial`) union all (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '3' and `data_off` > '1172729640' group by `dzial`) union all (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '4' ...

  1. #1

    Default travial querry - why this doesnt work (MsSQL user:) )

    helo!
    i work as MSSql admin, soo i believe thats trivial problem. i have querry,
    which doesnt work in MYSQL, pleae help:

    --- START ---
    select * from
    (
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '1'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '2'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '3'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '4'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '5'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '6'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '7'
    and `data_off` > '1172729640' group by `dzial`)
    union all
    (select `dzial`, count(*) as `ile` from `ogloszenia` where `dzial` = '8'
    and `data_off` > '1172729640' group by `dzial`)
    ) as _x
    inner join (
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '1' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '2' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '3' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '4' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '5' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '6' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '7' group by
    `dzial`)
    union all
    (select `dzial`, count(*) from `ogloszenia` where `dzial` = '8' group by
    `dzial`)
    ) as _y on _x.dzial = _y.dzial
    ---- END ----

    BM
    --
    Używam klienta poczty Opera Mail: http://www.opera.com/mail/
    maria Guest

  2. #2

    Default Re: travial querry - why this doesnt work (MsSQL user:) )

    On 1 Mar, 06:36, maria <pl> wrote: 

    May I respectfully request that before we help, you help!
    You say "i have querry, which doesnt work in MYSQL,..."
    Do you tell us what doesn't work? No!
    Do you get a syntax error?
    Do you get the wrong results?
    Do you give us any clue?

    Captain Guest

  3. #3

    Default Re: travial querry - why this doesnt work (MsSQL user:) )

    On Mar 1, 9:44 am, "Captain Paralytic" <com> wrote: 


    >
    > May I respectfully request that before we help, you help!
    > You say "i have querry, which doesnt work in MYSQL,..."
    > Do you tell us what doesn't work? No!
    > Do you get a syntax error?
    > Do you get the wrong results?
    > Do you give us any clue?[/ref]

    First thought - don't all derived tables require aliases?

    strawberry Guest

Similar Threads

  1. flash app doesnt work
    By zardon222 in forum Macromedia Flash Player
    Replies: 0
    Last Post: December 2nd, 11:56 PM
  2. Shockwave doesnt work
    By bills150 in forum Macromedia Shockwave
    Replies: 0
    Last Post: November 16th, 12:33 PM
  3. redirect to guest if first redirect is doesnt work for a user
    By istalcup@hotmail.com in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 17th, 03:27 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