Click here to Skip to main content
13,706,648 members
Rate this:
 
Please Sign up or sign in to vote.
i work sql server

i want to appear data from 2 table (Have relationship)
but i have problem

the first table

ID Name Date Adress
1 Ahmed 3223 23
2 Rone 45 dsd


the Second table
ID ID Booking Place Period Mobile
1 1 Madi 12 546546
1 2 Dar 10 546546
1 3 sayda 5 23131
2 4 zhra 8 2487
2 5 sdf 898



As this
ID Name Date Adress ID Booking Place Period Mobile
1 Ahmed 3223 23 1 Madi 12 546546
2 Dar 10 546546
3 sayda 5 23131
2 4 zhra 8 2487
5 9 898

No This :

ID Name Date Adress ID Booking Place Period Mobile
1 Ahmed 3223 23 1 Madi 12 546546
1 Ahmed 3223 23 2 Dar 10 546546
1 Ahmed 3223 23 3 sayda 5 23131
2 Ahmed 3223 23 4 zhra 8 2487
2 Ahmed 3223 23 5 9 898

How I can do it

because i do it in the report
thanks
Posted 12-Nov-13 22:51pm
Comments
Amitava Bag (Kolkata) 13-Nov-13 6:22am
   
Want to more clear...
Table-A
ID Name Date Adress
Table-B
ID ID Booking Place Period Mobile

Q1. You can't specify repeat field name as in Table-B. Please rectify same.
Q2. Can you explain the realtionship. Like I assume for Table-A ID is the primary key. What is PK for Table-B and specify the FK also.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web01-2016 | 2.8.180920.1 | Last Updated 13 Nov 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100