Merging data in two data fields with SQL

[james_hanify]

Hi all,

So my data structure is a bit annoying but what I have is an invoice, invoicedetails and inventory. I am using SQL to pull the information initially so i assume i'll have to do two or more passes on the data, though the more efficient route would be my preferred option.

If it is a custom item, the details of it will be stored in inventory, i was going to do similar to this

if invoicedetails hasn't got the product information then get it from the inventory.

Then the item's proper detail can be added as another table, only the name is kept within invoicedetails.

Example:

InventoryDetails

InvoiceItemKey	ItemKey	ProductDescription
JIGS*SALE*I1234*1	G000AAA	Custom Cable
JIGS*SALE*I1234*2	MD233BA
JIGS*SALE*I1235*1	NS-3929BA

Inventory

ItemKey	ProductDescription
MD233BA	Apple madness pro
NS-3929BA	Some amazing device

JOINED InventoryDetails

InvoiceItemKey	ItemKey	ProductDescription
JIGS*SALE*I1234*1	G000AAA	Custom Cable
JIGS*SALE*I1234*2	MD233BA	Apple madness pro
JIGS*SALE*I1235*1	NS-3929BA	Some amazing device

Many thanks,

James.

[vinieme12]

No,  there is no limit .

Do you get any error message?

[james_hanify]

School boy error, i copied and pasted and forgot to change the as name

Thanks