Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f86H5m734314 for ; Thu, 6 Sep 2001 13:05:48 -0400 (EDT) (envelope-from pgsql@symcom.com) Message-Id: <200109061705.f86H5m734314@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Thu, 06 Sep 2001 13:11:30 -0400 Date: Thu, 06 Sep 2001 13:11:30 -0400 From: "postgresql" To: "PgSQL-SQL" Subject: X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200109/20 X-Sequence-Number: 4666 I am basically self taught with sql. I find that I keep re-reading the postgresql tutorials tryin to add a little more to my understanding. so my question is... Is this the best way to word this querry? I have two tables, fc_client_info and fc_communication. I keep reading the section on JOINs and wonder if I should querry this differently. for some reason I have been shying away from JOINs (I haven't figures them out). SELECT i.cname FROM fc_client_info i, fc_communication c WHERE i.acode = c.acode AND c.contactdate = '09/06/2001' ORDER BY lower(cname); Thank for your great software.... I am really beginning to like SQL... Ted