Click here to Skip to main content
15,304,711 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900