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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL query with CASE or subquery?
Thanks, lespaul! I'm going to try what you suggest, but I'm also wondering if there is a way to do it using one or more subqueries. My application is using ASP.NET and my data access layer prefers subqueries to joins (at least that's how I've interpreted the warnings I've seen. I will post...- bwwhite
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL query with CASE or subquery?
My database stores bowling scores from my bowling league. I have a table of bowlers' names and their previous year's averages and handicaps. I have another table to record current weekly league results. My 2 Access data tables look like this BowlerTable: year bowler_id team_id lyr_ave...- bwwhite
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
