Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

One-to-many relationship select query with one row from many side Expand / Collapse
Author
Message
Posted Friday, July 30, 2010 1:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 3:42 AM
Points: 6, Visits: 19
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_ID F_Name M_Name L_Name
1 A B C
2 X Y Z

Table B
B_ID A_ID City State Zip
1 1 xxx TN 37013
2 1 yyy TX 37012


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

I appreciate all the help...
Post #961603
Posted Friday, July 30, 2010 1:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 3:42 AM
Points: 6, Visits: 19
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.
Post #961607
Posted Friday, July 30, 2010 8:05 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 5,563, Visits: 24,696
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

Before posting a performance problem please read
Post #961677
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse