Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
i have the following 2 tables:
i want to joint the expiration date to the item ledger entries table.
so basically where the item no + document number is the same in both tables, then bring in the expiration date into the item ledger entries table.
i hope someone can assist with this!
You can move ahead with this existing model (with synthetic keys - as being shown in your model screen shot; please remember synthetic keys are NOT bad if they are not incorrectly modeled). Or, you could create a composite key to associate the fields.
Hi,
That's a very simple join to make.
left join(ITEM LEDGDER ENTRIES)
LOAD
[Item no],
[Document no],
[Expiration Date]
Resident [Ambassador Packing List];
drop table [Ambassador Packing List];