Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
raynac
New Contributor III

Excluding records with the script

I am annoyed with myself for having to ask this, because I am sure it's a simple thing but I can't seem to get it to work.

In my company's database, you can have bookings with no rooms and rooms with no bookings.  This view centres entirely on bookings (both with and without rooms) and I want to make sure the rooms without bookings don't show up at all.

So I load the booking table, and then with the rooms table, my statement is this:

SQL SELECT *

FROM $(TBLPRE)rooms u JOIN $(TBLPRE)bookings b on

u.group_reservation=b.reservation_number where b.reservation_number>0 ;

I also tried

SQL SELECT *

FROM $(TBLPRE)rooms u RIGHT OUTER JOIN $(TBLPRE)bookings b on

u.group_reservation=b.reservation_number where b.reservation_number>0 ;


What am I missing?

Tags (2)
Community Browser