From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: outer join in ms query
Date: Mon, 18 Apr 2005 09:51:10 -0500
Message-ID: <d40hgq$15ff$3@news.hub.org> (raw)
References: <91d2a328e2c04b1086807bac8910c34c@DBMonster.com>
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" <forum@nospam.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jeff_eckermann@yahoo.com
Subject: Re: outer join in ms query
In-Reply-To: <d40hgq$15ff$3@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox