Good morning,
I must still be drowsy from the weekend. Where am I going wrong
in this create view. I am ending up with way more data than I
need. The f_name, L_name is repeated for every piece of equipment
found in t4 then starts over with the next f_name, l_name
create view clubnewv as select t1.f_name, t1.l_name, t1.badr,
t1.badrst,t2.jobid,
t2.jobadd1,t2.jobadd2,t3.sa_invoice_number,t4.sa_EQMT_kind from
ARmain t1, jobsite t2, sa_main t3, sa_detail t4 where t1.custno =
t2.custno and t2.jobid = t3.jobid and t3.sa_status <> "closed" and
t2.jobid in (select jobid from joblist
where finalbill between .vsavstrtdate and .vsavenddate)
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
