Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • RE: Finding the right JOIN type

    Hurray! :w00t: :w00t: :w00t:

  • RE: Finding the right JOIN type

    Folks, did you see that?! I'm not a grasshopper any more! I'm now SSC Rookie! :w00t:

    Could anyone explain to me, a ukrainian, what does it mean? Which meaning from enumerated...

  • RE: Finding the right JOIN type

    reliableitservice (6/15/2012)


    I can tell you the the work is done.

    Do you mean you achieved the following?

    reliableitservice (6/11/2012)


    DESIRED results

    STYLE LBL DIV

    2204852 GOSSIP JUNIOR

    Did suggested scripts do the desired work? Or you're...

  • RE: Finding the right JOIN type

    Sean Lange (6/14/2012)


    At this point it seems the two of you are putting in far more effort on this than the OP. 😉

    Yes, it is! I'm a newbie in SQL...

  • RE: Finding the right JOIN type

    ChrisM@Work (6/14/2012)


    What I'm hoping to do is encourage the OP to find out for sure how these tables are supposed to relate to each other.

    Me too, I think this should...

  • RE: Finding the right JOIN type

    OK. But OP wrote that the new data should be appended: «If you add the one listed below,

    you will get the same I am getting.»

  • RE: Finding the right JOIN type

    ChrisM@Work (6/14/2012)


    My query returns 3 rows 😉

    The following code contains 4 sections:

    --in this section I create an example database

    --this is code posted by OP in Post #1314145

    --this is additional code...

  • RE: Finding the right JOIN type

    By the way, I'd like to pay attention on one interesting detail:

    there is no need to look into the zzxpgtyr table to determine, which group_type corresponds to a given pkey....

  • RE: Finding the right JOIN type

    Nevertheless, I still don't understand, what are you trying to do?

    I agree with you that in this example it looks strange: why they didn't call 'group_codeN' columns as 'lbl', 'print',...

  • RE: Finding the right JOIN type

    ChrisM@Work (6/14/2012)


    Anatoly Ukhvanov (6/14/2012)


    I didn't even understand what is it for? What does this code do?

    For example, the first method returns this:

    What is it? reliableitservice wrote (Post #1314145) he/she wants...

  • RE: Finding the right JOIN type

    I didn't even understand what is it for? What does this code do?

    For example, the first method returns this:

    What is it? reliableitservice wrote (Post #1314145) he/she wants this as results:

    reliableitservice...

  • RE: Finding the right JOIN type

    reliableitservice (6/13/2012)


    From the Post #1314836,

    is this the rest of the tables I had posted at the beginning of the post from the attached?

    Yes, it is.

    reliableitservice (6/13/2012)


    It worked in your server...

  • RE: Finding the right JOIN type

    reliableitservice (6/13/2012)


    HI Grasshopper,

    reliableitservice, I'd like to notice that Grasshoper isn't my name, it's my «user level» on this forum. My name is Anatoly (page in Wikipedia). :hehe:

  • RE: Finding the right JOIN type

    ChrisM@Work (6/13/2012)


    No, it's spam, reported.

    Thanks, I'll «store it in my mind». 🙂

    P. S. Did I choose the correct English idiom? Do American/English people say like this? (I'm from Ukraine,...

  • RE: Finding the right JOIN type

    enling112010, are you reliableitservice?

Viewing 15 posts - 1 through 15 (of 29 total)