HOw i can Join between two table witout Repeat the columns in the first table

See more:

SQL-Server

relationship

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