Are all the common columns joined between the tables? Sometimes, missing a
pair of columns will create an effect similiar to this.
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan
Posted At: Monday, April 14, 2008 9:15 AM
Posted To: RB7-L
Conversation: [RBASE-L] - Help with Create View
Subject: [RBASE-L] - Help with Create View
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
