Single table row-column comparison issue

  • 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