[KLUG Members] Advanced SQL Questions (Smart Views)

[Buist Justin]

-----Original Message-----
From: Adam Williams [mailto:adam@morrison-ind.com]
Sent: Friday, May 03, 2002 2:47 PM
To: members@kalamazoolinux.org
Subject: [KLUG Members] Advanced SQL Questions (Smart Views)

[snip]
If I just do 

create veiw equipment_detailed
  (equip_id, make, model, serial, rental_asset, rented_yn)
 AS select equipment.equip_id, make, model, serial,
           rental_asset, rented_yn
     from equipment, rental_equipment
    where equipment.equip_id = rental_equipment.equip_id

[ end snip ]

perhaps your WHERE clause should read:
where equipment.eqip_id = rental_equipment.equip_id
   OR equipment.equip_id NOT IN (select equip_id from rental_equipment)

.. Probably going to be slower than pooh, but it might not be too bad.


Justin Buist