Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
Please provide me your requirement. I will try to prepare SQL query for it.
Can you share your database with me or simply the table structure. I want to set up similar environment on my PC
I tried but I am not getting expected result. I am opting out so that some other expert can help you in it.
Hi. I won't opt out on you. Kindly explain what the issue is. That's an awfully lengthy DDL for such a limited, er, scope of commitment.
You need the results? If you have the structures and the data, why don't you just run the query and save the results? What am I not understanding?
"Joined as shown in the query below." No, actually, that's how YOU chose to join them for I-know-not-what reason. I need PRECISE table structures that tell me what the key fields are and what the inter-table referential integrity constraints are.
"It's a group" and "based on KUAF.GroupID values" and such are far too vague to make this doable in the least. I need a PRECISE spec of what facts you want to obtain.
Databases are all about precision, not about vague, freewheeling indications of "I just need this" and "like I did below."
Please advise. Thank you for your cooperation.
Well, yes, I need to know what information you're trying to retrieve from your query that evidently didn't work.
Can you express it in a precise form, like predicate calculus? Or just be as descriptive as possible:
"For each value of X in T, I want to find the corresponding value of Y in Q, and, for each P that matches that Y, count the # of distinct values of R." That sort of thing.