| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> that, or I beat him again
<0> rinse, repeat
<0> what's wrong
<0> when justinm asks you what's wrong, you ****ing answer him
<1> beat gollem and nurse him back to health, and you won't be waking up one day :)
<2> luckily I won't run out of beer
<3> Narbs: SELECT blah, (SELECT DISTINCT blah FROM table2 WHERE table2.value = table1.value) FROM table1 .. I think something like that, if I'm understanding you correctly
<0> Drk`Angel: probably, but it would still be fun
<0> that gimp
<4> cubert; yea it looks like you were the only one who know what they're doing
<3> not hardly
<1> Oh, I know what you're asking. I just think its stupid.
<3> I was the only who gave a **** an answered
<1> And no, that won't work. :)
<3> it sounds to me like your data is kinda fubared
<4> it's for a very specific situation
<3> Drk`Angel: I wasn't sure if you needed table2 in the outer FROM or not, I figured he could play with it and see what worked
<4> I could take care of it in the business layer but I'd rather do it with a query
<5> *every* nutso request is "for a specific situation" or something "we don't understand"
<3> give him the concept and let him run with it... or scissors...
<1> You can't put an inlin select in the field list if it returns more than oen record
<1> inline*
<3> Drk`Angel: SELECT DISTINCT only returns one record ;P
<3> err... no it doesn't
<3> I'm stupid
<1> :)
<3> SELECT TOP 1
<3> or .. um... FETCH FIRST 1 if it's DB2
<1> At least, you can't in oracle or mssql. Other rdbms, who knows.
<1> IRC is hell anyawys.
<5> eh, good point
<1> Especially efnet.
<5> lol
<1> Its the hellest? :)
<5> It's "hella good" IRC
<0> ill make you moan baby
<6> justinm : i'll make *you* moan...
<5> I feel like I've stepped into the IRC Twilight Zone today; you should see FreeNode and Undernet
<2> I think some gate burst today
<2> like the gate of hell, or the gate of n00bs
<3> that was my appendix
<5> interesting theory, that
<3> oh wait, I had my appendix out on my 30th bday
<2> well, judging by the questions in the channels it's not much of a theory
<2> it's more of a fact
<2> :P
<2> something happened today, and it was not good
<3> I think me and Mr. Jack Daniels are going to have a good old time tonight
<2> yeah, I've stocked up on beer to get through the night
<2> good ol' jack is handy too
<3> http://www.fiveinabox.ch/Miso/Fastdrive.gif
Return to
#sql
or
Go to some related
logs:
#politics
#beginner
#worldcup
#computers
#beginner
#microsoft
#cisco
google/crayola
#beginner
#beginner
|
|
