dan@hrc.UUCP (Dan Troxel) (05/31/89)
What I need to do is get data from three tables. billing is the main table and has the bill info acctrec is the info table on the client hwstat has the name of the individual for this entry of the bill At times, hwstat will not have a record found, but I still want the rest of the info printed. The following does not work, so what do I do to correct the situation? ------------cut me--------------------- lines 0 select billing.bkey, billing.id_num, billing.writnum, billing.reference, billing.units, billing.bill_date, billing.description, billing.unit_cost, billing.extension, billing.taxable, billing.discount, billing.command, billing.bill_num, billing.bill_make, billing.bill_make_date, billing.bill_pay_date, acctrec.company,hwstat.writers_name from billing, acctrec, hwstat where billing.id_num between 100 and 150 and acctrec.id_num = billing.id_num and billing.bill_date <= 05/31/89 and hwstat.client = billing.id_num and hwstat.writing_num = billing.writnum order by billing.id_num,billing.bill_num,billing.bill_date/ -- Dan Troxel @ Handwriting Research Corporation WK 1-602-957-8870 Camelback Corporate Center 2821 E. Camelback Road Suite 600 Phoenix, AZ 85016 ncar!noao!asuvax!hrc!dan zardoz!hrc!dan hrc!dan@asuvax.asu.edu