Home Forums SQL Server 2008 T-SQL (SS2K8) Any better way of querying multiple tables based on a column value? RE: Any better way of querying multiple tables based on a column value?

  • June 21, 2018 at 8:01 pm

    #1994933

    sgmunson - Thursday, June 21, 2018 3:48 PM

    Yep, I have to agree with Sean.   This whole thing is a head-spinner.   How about a 30,000 foot overview of what, in the REAL world, the data is actually going to represent.   Don't assume that anyone knows ANYTHING about your business or it's objectives.   Then state what you are trying to accomplish by storing the data, and what kind of output you are going to need.   Explain the WHY, and that might help us get you better answers.

    I'm really not sure what more I can explain. My latest post is literally exactly the problem I'm trying to solve. The table design and specifications are as close to the actual real-world ones as I can get. If you have any suggestions on how I can clarify the problem better, please let me know :/

    And I suppose I should make one thing clear - I'm not dealing with a problem for which I have no solution. I have a solution, and I'm just asking if there is a better approach than the one I've taken.

    To abstractify the situation a bit, the scenario is that I have a One-to-Many-to-Many relationship for which I need to design tables to store data and queries to access. The design I chose is to represent this instead as a One-to-Many-to-One relationship, where the latter "one" is represented by the ItemTypeID-ItemID concept.