Contact
Booking
Trip
Search
Task3


SQL Search

Please anter your code and press Save to find results!

Task2:

SELECT contact.SubscriberKey, contact.firstname, contact.lastname, contact.emailaddress FROM contact WHERE contact.SubscriberKey NOT IN (SELECT trip.SubscriberKey FROM trip)


SQL Code
Warning: Undefined array key "sql_code" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 52
1
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Hubert
Dziewulski
hubert.dziewulski@interia.pl
725077210
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
2
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Hubert
Dziewulski
erthub2@gmail.com
725077210
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
3
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Karol
Mikuła
karol5@amorki.eu
1255125531
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
4
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Marian
Latawiec
marian@wp.pl
1255125531
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
5
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Anna
Nowak
annanowak@wp.pl
665500223
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
6
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Jolanta
Duda
jolantaduda@amorki.eu
1255125531
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
7
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Marian
Paździoch
dziewulski@erthub.ct8.pl
888777666
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
8
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Anna
Michałko
t.dziewulski@erthub.ct8.pl
888999222
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
9
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Adam
Nowacki
rt.dziewulski@erthub.ct8.pl
555666777
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
10
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Patrycja
Markowska
ert.dziewulski@erthub.ct8.pl
111222333
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
11
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69

ziewulski@erthub.ct8.pl
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102
12
Warning: Undefined array key "TripID" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 69
Marian
Nowak
hubert.dziewulski@erthub.ct8.pl
1255125531
Warning: Undefined array key "bookingid" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 84
Warning: Undefined array key "departuredate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 87
Warning: Undefined array key "arrivaldate" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 90
Warning: Undefined array key "price" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 93
Warning: Undefined array key "hotelname" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 96
Warning: Undefined array key "hoteladdress" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 99
Warning: Undefined array key "hoteldescription" in /usr/home/erthub/domains/kingsizetravel.ct8.pl/public_html/index4.php on line 102