Viewing 15 posts - 91 through 105 (of 152 total)
Sorry, I left out that some of the ItemNum SKU's do have letters in the ItemNum field....but I want to ignore any of those ItemNum fields...ONLY the ones that have...
March 15, 2017 at 11:55 am
March 15, 2017 at 11:53 am
Update MyTable1March 13, 2017 at 10:45 am
Ok, so I have read over n over you cannot delete related data from 2 tables in one query. I guess a FK is the way to go, never written...
March 9, 2017 at 9:03 pm
Thank you, but I am still unsure how to move the SKU's with an...
March 9, 2017 at 4:07 pm
March 9, 2017 at 9:23 am
UPDATE Inventory_TagAlongs
set TagAlong_ItemNum = 'CRV- Under...
March 8, 2017 at 8:10 am
Select Inventory_tagalongs.itemnum, Inventory_tagalongs.store_id,Inventory_tagalongs.tagalong_itemnum, Inventory_tagalongs.quantity
from Inventory_tagalongs
LEFT JOIN tagalonglist
ON Inventory_tagalongs.store_id = tagalonglist.store_idtagalong_itemnum
Man i suck at this! All 4 fields return data, no errors. And I have...
March 1, 2017 at 2:20 pm
March 1, 2017 at 2:10 pm
February 9, 2017 at 11:59 am
Viewing 15 posts - 91 through 105 (of 152 total)