question

Janvi asked Mar 24, '19

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.

query joins rdbms

2

10 |1200

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

KenJ commented · Mar 24, 2019 at 07:12 PM

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 ·

Janvi commented · Mar 25, 2019 at 12:27 AM

img-20190325-055204.jpg

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

Please help.

0 ·

img-20190325-055204.jpg (196.6 KiB)