X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BE31653875 for ; Mon, 18 Apr 2005 11:51:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36454-06 for ; Mon, 18 Apr 2005 14:51:12 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5B1C2536EA for ; Mon, 18 Apr 2005 11:51:10 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 5997130952; Mon, 18 Apr 2005 16:50:13 +0200 (MET DST) From: "Jeff Eckermann" X-Newsgroups: pgsql.sql Subject: Re: outer join in ms query Date: Mon, 18 Apr 2005 09:51:10 -0500 Organization: Hub.Org Networking Services Lines: 36 Message-ID: References: <91d2a328e2c04b1086807bac8910c34c@DBMonster.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.359 tagged_above=0 required=5 tests=FORGED_YAHOO_RCVD, PRIORITY_NO_NAME X-Spam-Level: *** X-Archive-Number: 200504/250 X-Sequence-Number: 21143 MS Query is crippled. If you want to do much from Excel, you will need to write code. But it's not difficult. ADO is a good choice for this. "gad renert via DBMonster.com" wrote in message news:91d2a328e2c04b1086807bac8910c34c@DBMonster.com... > Hello, I am a novice with SQL, I have 2 tables > (transfer) > bar_code | quant | date > 723445...| 2 |01/03/2005 > > (imports) > > bar_code | serial_no | supplier > > > I want to add to the first table (transfer) > next to each barcode the suppliers name from the (imports) table. > > ms query doesn't allow me to do outer joins. > > I tried: > SELECT transfer.bar_code, transfer.quant, imports.supplier > FROM transfer left join imports on transfer.bar_code=imports.bar_cod > GROUP BY transfer.bar_code > > and it didn't work popperly, the (transfer) table is modified. > what i want to do is very similar to the VLOOKUP function in EXCELL > > Hope that someone can help me. > > Gadi > > -- > Message posted via http://www.dbmonster.com