Thanks for your help, but I was wondering if you could maybe structure your answer in a real world example. I think that's why I am struggling with this stuff...

• This reply was modified 5 years, 2 months ago by  Data Rat .
• This reply was modified 5 years, 2 months ago by  Data Rat .

That's Excellent. Thanks !!!!

Thanks for your comment. But why would you use an inner join instead of a left join?

Thanks for your help. But will this query partition the resultset by City? Meaning will I be able to see all of the Cities and Companies? Or will it rollup...

Thanks for your help. I want to show only the columns City and Company Name. I dont want to show  column City with a count of the Cities per partition.

In the example scenario that you used would you combine the primary  key and the foreign key so that your orders would be unique? Because I thought that would be...

Thank You for your help. I understand why a table can have multiple foreign keys. But you commented about sometimes you will have both a foreign key and primary key...

Thanks Everyone for your help. You showed me 2 different ways of doing this. All I need to do is group by Gender and use the COUNT function. This is...

I have spent a lot of time trying. I tried using group by, but I think it's a little more complex than that. But Thanks for your help

I was just wondering what method are you using as far as which tables to join with the tables you chose. And why did you use the AND clause

Thanks for your comment. I thought it gave me some additional insight into design which is what I was asking for. It sounds like you are saying that I will...