Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

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