Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL Question. I currently have two SQL tables One table called Waitlist and one Called Booking. They are not identical (waitlist contains more information than
SQL Question.
I currently have two SQL tables One table called Waitlist and one Called Booking. They are not identical (waitlist contains more information than booking). They appear like so:
Waitlist:
# | Customer | Day | Timestamp | Flight |
1 | Joseph | 2017-04-22 | 2017-04-22 16:20:33.178 | F101 |
Booking:
# | Customer | Flight | Day |
1 | Timmy | F101 | 2017-04-22 |
2 | Joseph | F101 | 2017-04-22 |
I would like to delete the duplicate data from waitlist (in this case the joseph entry).... I have tried the following:
DELETE FROM Waitlist WHERE Customer = booking.customer and day = booking.day and flight = booking.flight
I have also tried an INNER JOIN with no luck.
Please Help!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started