Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format

Links

XODOX
Impressum

#1: outer join in ms query

Posted on 2005-04-16 19:20:35 by forum

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

Report this message