عرض اكثر من عمود من جدولين بشرط معين "استخدام Join"

[sma14161]

A.   Display the following columns from Guests , Reservation  tables to show all  guests whether they made reservation or not .

National ID, Full name, email, mobile number, reservation no, date of reservation, room no. duration.A.   Display the following columns from Guests , Reservation  tables to show all  guests whether they made reservation or not .

National ID, Full name, email, mobile number, reservation no, date of reservation, room no. duration.

 

حيث ان فيه علاقة برايمري كي وفورن كي بين الجدولين ,, مش راضي يطلع العناصر كلها باستخدام join !!!! 

  

[sma14161]

ضروري يا جماعة التسليم بكره وهذا اخر سوال

[eslam elbyaly]

Google about Oracle Joins.

[Ahmed_oracle]

select Guests.National_ID, Full_name, email, mobile_number, reservation_no, date_of_reservation, room_no , duration

from Guests , Reservation

where Guests.National_ID = Reservation.National_ID;

[sma14161]

select Guests.National_ID, Full_name, email, mobile_number, reservation_no, date_of_reservation, room_no , duration
from Guests , Reservation
where Guests.National_ID = Reservation.National_ID;

ضبط معي لكن الديوريشن عيا ما ادري ليه ,,, شكككككككراَ جزاك الله خخيرررر 

[Ahmed_oracle]

اعرض وصف الجداول التي لديك وتعمل عليها 

 

فهل room no. duration عمود واحد 

او

عمودين

room_no , duration