Excluding records with the script

raynac — Mon, 25 Aug 2014 16:43:52 GMT

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?

topic Excluding records with the script in QlikView

Excluding records with the script