Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!ncar!asuvax!mcdphx!xroads!hrc!dan From: dan@hrc.uucp (Dan Troxel) Newsgroups: comp.databases Subject: How do I get SQL (Unify 4.0) to pull all linked Message-ID: <1991May7.000450.1699@hrc.uucp> Date: 7 May 91 00:04:50 GMT Organization: Handwriting Research Corporation Lines: 33 How do I get all records from table_1, even though some records in table_1 are not linked to table_2??? select table_1.field_1, table_2.field_2 from table_1, table_2 where table_1.field_1 = table_2.field_1 This will pull only those records that match in both tables per the where clause. I want to get all records in table_1, whether or not they match any records in table_2. So that I might get an end result as follows: table_1.field_1 | table_2.field_2 ----------------------------------------------------------------- 3001 | linked note... 3002 | linked note.... 3003 | 3004 | linked note.... 3005 | instead of: table_1.field_1 | table_2.field_2 ----------------------------------------------------------------- 3001 | linked note... 3002 | linked note.... 3004 | linked note.... Any help *will* be appreciated. -- 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.eas.asu.edu