question

Janvi avatar image
Janvi asked

I have 3 columns namely Users, Tickets and booking details, but I'm unable to join the three columns to display the details of customers not using hdfc bank.

Display user name and their city who have booked their tickets not by using HDFC bank for any of the bookings. Sort the result based on user name.

queryjoinsrdbms
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

do you have table definitions with sample data? that would really help us to help you.

what have you tried so far? are the columns in different tables? what should we join on? how would we know whether or not a user booked using HDFC bank?

0 Likes 0 ·

img-20190325-055204.jpg

Hi, @KenJ, I'm attaching the table definitions below.

Please help.

0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.