pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: outer join in ms query
2+ messages / 2 participants
[nested] [flat]
* Re: outer join in ms query
@ 2005-04-18 14:51 Jeff Eckermann <jeff_eckermann@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jeff Eckermann @ 2005-04-18 14:51 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: outer join in ms query
@ 2005-04-18 15:13 Philippe Lang <philippe.lang@attiksystem.ch>
0 siblings, 0 replies; 2+ messages in thread
From: Philippe Lang @ 2005-04-18 15:13 UTC (permalink / raw)
To: pgsql-sql
Or add a view to your PG database, and simply issue a select from Excel... That faster and easier to maintain that any code you can write client-side...
-----Message d'origine-----
De : pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] De la part de Jeff Eckermann
Envoyé : lundi, 18. avril 2005 16:51
À : pgsql-sql@postgresql.org
Objet : Re: [SQL] outer join in ms query
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-18 15:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-18 14:51 Re: outer join in ms query Jeff Eckermann <jeff_eckermann@yahoo.com>
2005-04-18 15:13 Re: outer join in ms query Philippe Lang <philippe.lang@attiksystem.ch>
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