Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Issues In Database Management A Refernce For The Thinking Practitioner

Authors: Fabian Pascal

1st Edition

0201485559, 978-0201485554

More Books

Students also viewed these Databases questions

Question

3. What information do participants need?

Answered: 1 week ago