July 20, 2011 at 5:47 am
Hello,
thanks for your kind answer.
I realize that you have limited SQL skills and hardly understand the code put by all people, but there is a previous question in your problem, related to database design rather than SQL Skills, let me explain:
In your problem you have two kind of Inventory Ids, those coded 'FLR-%' and those coded 'PX-%'. As you pointed out, this two groups of inventory ids are related. The question: how can you express this relation?.
Maybe you can express this relation using a formula. As you explained, after 'FLR-' there is a digit, after 'PX-' there is another digit, and both digits must be equals for a related ids; in this case, you must be able to code this formula. That's corresponding to mister Magoo and Jeff's approaches.
Or you cannot express this relation using an (easy enough) formula; in this case you must define a new table containing all related pairs of inventory ids. That's my approach.
What's your scenario?, that's a main question, and answer it is a previous step to code any solution.
Hope it helps,
Francesc
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply