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 : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 ---------------------------(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
