Re: outer join in ms query

Or add a view to your PG database, and simply issue a select from Excel... That faster and easier to maintain that any
codeyou 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
agood 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