[SQL] JOIN not being calculated correctly

2004-10-30 Thread Scott Pederick
ld be greatly appreciated. I've taken it as far as I can and don't really know where to move from here. Thanks in advance, Scott Pederick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [SQL] JOIN not being calculated correctly

2004-11-20 Thread Scott Pederick
producttypeid_fkey FOREIGN KEY (producttypeid) REFERENCES producttypes(producttypeid) ON UPDATE RESTRICT ON DELETE RESTRICT; CONSTRAINT jobs_quarryid_fkey FOREIGN KEY (quarryid) REFERENCES quarries(quarryid) ON UPDATE RESTRICT ON DELETE RESTRICT; CONSTRAINT jobs_salesid_fkey FOREIGN KEY (salesi