-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3.sql
9 lines (9 loc) · 891 Bytes
/
3.sql
1
2
3
4
5
6
7
8
9
print("LIST EXITING BOOKINGS")
curs = connection.cursor()
cursInsert = connection.cursor()
user_email = input("Please enter your email: ")
user_email = "'"+user_email+"'"
#SQL STATEMENT?
#SELECT UNIQUE bookings.tno, passengers.name, bookings.dep_date, tickets.paid_price FROM #bookings, passengers, tickets WHERE bookings.tno=tickets.tno AND passengers.email=tickets.email AND passengers.name=t\
ickets.name;
#Im not sure if it is correct, is it really is this simple...?