X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1BCA99DCC99 for ; Sun, 4 Dec 2005 08:31:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28264-04 for ; Sun, 4 Dec 2005 08:31:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp105.sbc.mail.re2.yahoo.com (smtp105.sbc.mail.re2.yahoo.com [68.142.229.100]) by postgresql.org (Postfix) with SMTP id 05E369DCBFF for ; Sun, 4 Dec 2005 08:31:55 -0400 (AST) Received: (qmail 40867 invoked from network); 4 Dec 2005 12:31:55 -0000 Received: from unknown (HELO epox2800) (michael.avila.1@sbcglobal.net@70.228.56.50 with login) by smtp105.sbc.mail.re2.yahoo.com with SMTP; 4 Dec 2005 12:31:54 -0000 From: "Michael Avila" To: "PostgreSQL SQL" Subject: SQL Statement Help needed Date: Sun, 4 Dec 2005 07:31:58 -0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0000_01C5F8A4.CF78E9A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MS-TNEF-Correlator: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.099 required=5 tests=[AWL=-0.700, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 2.099 X-Spam-Level: ** X-Archive-Number: 200512/14 X-Sequence-Number: 23556 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C5F8A4.CF78E9A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am not much of a SQL guru so I am having trouble trying to figure out how to format a SQL statement. I have a table with members named members. Each member has only 1 record. Then I have a table with member telephone numbers in it name membertelephones. A member can have more than one telephone number (home, work, cell, pager, fax, etc.). I want to print out the telephone numbers of the members. Is it possible to do it in one SQL statement like with a JOIN or something or do I need to get the members and then loop through the membertelephones to get the telephone numbers? Is it possible to do a JOIN with a table with one record with a table with multiple records? SELECT * FROM member SELECT * FROM membertelephone WHERE member_id = the id from the above SELECT Thanks for the help. Mike ------=_NextPart_000_0000_01C5F8A4.CF78E9A0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IjoMAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANUHDAAEAAcAHwAAAAAAEgEB A5AGADQGAAAiAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAGgAAAFNRTCBTdGF0ZW1lbnQgSGVscCBuZWVkZWQAAAACAXEAAQAAABYAAAABxfjOt8blKk5I NTZLR4fUuLe4VlVNAAACAR0MAQAAACMAAABTTVRQOk1JQ0hBRUwuQVZJTEEuMUBTQkNHTE9CQUwu TkVUAAALAAEOAAAAAEAABg4AmjKVzvjFAQIBCg4BAAAAGAAAAAAAAABIYB5heDLREb33REVTVAAA woAAAAsAHw4BAAAAAgEJEAEAAABwAgAAbAIAAA0EAABMWkZ1UAQ4lwMACgByY3BnMTI1FjIA+Atg bg4QMDMz/wH3AqQEZQhVB7ICgwBQA9QJAgBjaArAc2V0MFYgBxMCgH0KgXYIkHfSawuAZDQMYGMA UAsDAQu1IEkgYW0gbgpvBUBtFGBoIG9mQxWABgBRTCBnCHB1eCBzbxVkEpATwA8gIKp0A2B1AmBl GBF5F+N5F0BmaRbhGIAIYAVAaPBvd1xsC4AYgRkhBbCXAMAFQBaEcwGQdGUHgP0CMC4aIxokFXAX sRiAFoD3AZEYcQPwdBYwB4AG0ASQHQQgbhWQCYAeBi4gRR8A0B32F6EEIAIgbHkgLDEgCXAFoWQc FCBUXmgJ8BzPHdgYEGUYcHDzGfAaUW51HjQLgCTQBUBfHpIaJB4UI8cfUUEfxmP/A5EiMwRgGYEd 4AORJCIjzqwgKBnwB4AsGiR3BbBsaywngCPQbCsQCrBnYwSQKxBmYXgrEBLQY+wuKR9gFXB3AHAF QBkR/nAFEC0BGbId4CjvHmEWUDcaJS4RHvdJJMEFQHBv7QQQaRhjF0BkF0AlESThayQiG0sgGjBr HaUWgEr4T0lOGiQFsRcwB4Ad4P8X4gWxMdEVcBpQHsEZESuwPy3kHhYAcDZhIdIJAG9w+yhhGDFn FjAuASWPJpM2ev0uTz8wrzGzNCoz1SKpJCLHIPQ+nx3xdWx0BSAYcQcg9DxgHClTRUxFQwBUICog RlJPTQ8fxkKvQ7w7aFdIRVLSRR4FX2ke0D07E0gB9wNSOxMBoG8iUUVUHCkhwD0AcGsEIBqxOxMh 0GxwfRwaTTOREcIKsQqAE4EAAU3ACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAKA CCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAABz eQEAAwAJgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAAeABKACCAGAAAAAADAAAAAAAAARgAA AABUhQAAAQAAAAQAAAA5LjAACwAWgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADABeACCAG AAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAGYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAA CwAEgQggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAALAAiBCCAGAAAAAADAAAAAAAAARgAAAACC hQAAAQAAAAIB+A8BAAAAEAAAAEhgHmF4MtERvfdERVNUAAACAfoPAQAAABAAAABIYB5heDLREb33 REVTVAAAAgH7DwEAAABUAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAA AE5JVEH5v7gBAKoAN9luAAAARTpcT3V0bG9va0RhdGFcb3V0bG9vay5wc3QAAwD+DwUAAAADAA00 /TcAAAIBfwABAAAAPQAAADxOQkJCTE5QSEFNQ0ZFTkRGSElEQ0VFR0hFR0FBLk1pY2hhZWwuQXZp bGEuMUBzYmNnbG9iYWwubmV0PgAAAAADAAYQ22u6JwMABxB9AgAAAwAQEAAAAAADABEQAAAAAB4A CBABAAAAZQAAAElBTU5PVE1VQ0hPRkFTUUxHVVJVU09JQU1IQVZJTkdUUk9VQkxFVFJZSU5HVE9G SUdVUkVPVVRIT1dUT0ZPUk1BVEFTUUxTVEFURU1FTlRJSEFWRUFUQUJMRVdJVEhNRU1CRVIAAAAA EWE= ------=_NextPart_000_0000_01C5F8A4.CF78E9A0--