Post reply

One-to-many relationship select query with one row from many side

  • July 30, 2010 at 1:23 pm

    #387474

    Hello to all,

    I am a having trouble in querying one-to-many relationship. let me describe the scenario here. my table structure is like this.

    Table A

    A_IDF_NameM_NameL_Name

    1ABC

    2XYZ

    Table B

    B_IDA_IDCityStateZip

    11xxxTN37013

    21yyyTX37012

    Now i want to select all the rows from Table A and only first respective row from Table B.

    I appreciate all the help...

  • July 30, 2010 at 1:37 pm

    #1200528

    Oopps i just see that i post this at wrong place. let me find correct thread and post there. i will wait here for any answers as well..

    Sorry folks.

  • July 30, 2010 at 8:05 pm

    #1200589

    OP reposted at

    http://www.sqlservercentral.com/Forums/Topic961609-1291-1.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply