Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pogo1
-
Comparing tables
Came up with another solution that seem to work. Maybe not as elegant. SELECT name FROM( SELECT name, COUNT(size) AS sizes FROM( SELECT s.name, t.size FROM Store AS s, StoreTshirt AS st, Tshirt AS t WHERE s.sid=st.stor AND st.tshirt=t.tid GROUP BY s.name, t.size )...- pogo1
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
-
Comparing tables
Actually, disregard the previously posted SQL code. This is more to the point: Below is the part where I try to find out how many different sizes of tshirts are in every store. SELECT s.name, COUNT(t.size) AS sizes FROM Store AS s, StoreTshirt AS st, Tshirt AS s WHERE s.sid=st.store AND...- pogo1
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Comparing tables
PHV: Well I haven't gotten as far as a single working SQL statement yet but the method I want to use is counting the number of unique sizes of Tshirts for every store and comparing with the count of rows in the table "Size". This is where I'm at currently (obviosly not complete): SELECT s.name...- pogo1
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Comparing tables
So I have these tables: I want to find the name of every store that has T-shirts of all sizes. Any suggestions?- pogo1
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
