r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Current Activity
- Viewing Thread 2 date ranges. Calculate overlapping time?
- Last Activity
- Today 04:57 AM
-
Older Activity
-
please show how the three tables are related (primary and foreign keys)Today, 04:54 AM1 replies | 28 view(s)
-
push grouping into subquery derived table in FROM clause versus correlated subquery in SELECT clause -- only a comparison of the EXPLAINs will decide...Yesterday, 08:10 PM3 replies | 55 view(s)
-
Yesterday, 05:20 PM3 replies | 62 view(s)
-
this would be where you use a subquery to pre-collapse one of the 1-to-many relationships, so that they don't "cross join" with the other oneYesterday, 05:18 PM3 replies | 55 view(s)
-
okay, sorry for the confusion TL;DR -- aliases are required in the FROM clause, recommended as hell in the SELECT clause you will smile when...Yesterday, 09:56 AM5 replies | 69 view(s)
-
i think your counts in that query will be largely wrong :)Yesterday, 09:11 AM5 replies | 69 view(s)
-
some pointers here ==> https://www.google.ca/?gws_rd=ssl#q=site:forums.devshed.com+joining+to+the+same+table+twiceYesterday, 08:44 AM5 replies | 69 view(s)
-
please show the original "very heavy" query, along with an EXPLAIN on itYesterday, 06:28 AM7 replies | 81 view(s)
-
no i fully expect them to i've just learned to always consider every possibility :) execution time is easy, just run them (remembering to...Yesterday, 04:08 AM5 replies | 102 view(s)
-
why wouldn't 456789 match 4567890454? why wouldn't 456789 match 456? why wouldn't 90 also match 4567890454?Yesterday, 04:06 AM10 replies | 118 view(s)
-
both look okay to me, but i'm not really a DBA how does execution time compare? oh, and do they actually produce the same results?July 23rd, 2014, 05:49 PM5 replies | 102 view(s)
-
i'm pretty sure this was a typo --ON set.bjt_id=set.id have you tried doing it the normal way? SELECT bet.* , set.otherColumn FROM...July 23rd, 2014, 11:37 AM5 replies | 102 view(s)
-
could you show us some represenative strings in both tables please, some that will match and some that won't having a hard time figuring out what...July 23rd, 2014, 11:32 AM10 replies | 118 view(s)
-
sorry, we do not do homework assignments on this siteJuly 19th, 2014, 03:16 PM1 replies | 111 view(s)
-
so, what indexes have you created? presumably that will work however, you don't need code in the SELECT clause because you already know what...July 19th, 2014, 03:14 PM3 replies | 123 view(s)
-
July 19th, 2014, 01:59 PM3 replies | 123 view(s)
-
July 19th, 2014, 01:58 PM2 replies | 110 view(s)
-
you have two one-to-many relationships in the same query, so of course the results will multiply, producing what i call "cross join effects" you...July 13th, 2014, 06:39 AM2 replies | 237 view(s)
-
if there were three tables -- players, dates, and player_dates -- then your table would be player_dates, the "association" or "relationship" or...July 13th, 2014, 06:33 AM1 replies | 193 view(s)
-
works for me... and to mitigate the space issue, you might limit it to 3 characters a hierarchy of access rights is pretty hard to implement...July 8th, 2014, 12:36 PM10 replies | 333 view(s)
-
i would typically start with the "natural" key (put in quotes because an abbreviated name that needs a fuller description in a separate table...July 7th, 2014, 08:04 PM10 replies | 333 view(s)
-
you're gonna hate me for saying this, but it would depend on volume testing and query profilingJuly 7th, 2014, 05:07 PM10 replies | 333 view(s)
-
would you please post your solution so that others who come upon this thread will be able to learn from itJuly 6th, 2014, 10:14 AM4 replies | 269 view(s)
-
1. bid_status con: dropping id and using name means all bid rows referencing this table will expand their row length pro: in some cases name is...July 6th, 2014, 10:13 AM10 replies | 333 view(s)
-
it's not just mysql, all databases are the same in this regard do the right thing in the right layerJuly 5th, 2014, 06:35 PM3 replies | 304 view(s)
-
i think you have to run your queries through phpmyadmin one at a time notice it barfed right after the CREATE DATABASE statementJuly 5th, 2014, 10:31 AM1 replies | 227 view(s)
-
queries return results in the form of tables what you are getting is perfectly normal you cannot "suppress" the "duplicated" user data on...July 5th, 2014, 03:49 AM3 replies | 304 view(s)
-
thanks, had it yesterday ;)July 2nd, 2014, 08:45 PM7 replies | 394 view(s)
-
you should actually try this with real (no pun intended) floats "equal" won't happen :)July 2nd, 2014, 07:27 PM7 replies | 394 view(s)
-
because you won't ever get a collision of numbers you have grasped the strategy perfectly... users can keep moving rows around (figuratively of...July 2nd, 2014, 10:50 AM7 replies | 394 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
closest join
July 24th, 201402:14 PMUser / Points
You gave 3937 toComment
3000 bonus points for xaprb link -
Thread / Date
Query help
August 24th, 201303:09 AMUser / Points
You gave 0 toComment
i would have expected some kind of suggestion for a new data model and not just the usual diatribe/rant about what's wrong with the current one -
Thread / Date
Display 2 queries in the same table?
November 6th, 201207:56 PMUser / Points
You gave 937 toComment
thanks for taking the time to give examples! very helpful for new developers -
Thread / Date
Update first X rows?
August 21st, 201209:29 PMUser / Points
You gave 937 toComment
what dan said -
Thread / Date
Putting condition in ON clause or WHERE clause
August 17th, 201209:18 AMUser / Points
You gave 937 toComment
very nicely explained, great tutorial -
Thread / Date
Trying to get a count of certain records - PHP/MYSQL
January 13th, 201202:04 PMUser / Points
You gave 937 toComment
nice explanation, guelphdad
-
Thread / Date
Problem with slow query
October 18th, 201103:47 PMUser / Points
You gave 2937 toComment
stefan is my tuning hero
-
Thread / Date
Complicated table join question.
September 15th, 201108:29 AMUser / Points
You gave 937 toComment
sweet
-
Thread / Date
Help with a query
June 5th, 201108:21 AMUser / Points
You gave 2937 toComment
lol
-
Thread / Date
Urgent help Find Replace Query
June 21st, 201009:36 AMUser / Points
You gave 937 toComment
nicely explained
Latest Reputation Received 423544 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
duplicate row in inner join
July 13th, 201408:34 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
double SUM
June 12th, 201406:24 AMUser / Points
You recieved 0 fromComment
Sniped!
-
Thread / Date
Select distinct column when all criteria from another column are met/found
May 12th, 201401:12 PMUser / Points
You recieved 6351 fromComment
haven't repped you in a while, and it's good to encourage the newbies who make the right calls. -
Thread / Date
Selecting fields from two tables
March 5th, 201405:22 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:57 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:52 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Left join weekdays and time interval
February 26th, 201402:51 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Query for multiple date ranges at the same time
February 13th, 201407:30 AMUser / Points
You recieved 3 fromComment
No Comment Made -
Thread / Date
Using Multiple Selects in One Query
January 15th, 201411:16 AMUser / Points
You recieved 5 fromComment
Wow! Now that is a query! -
Thread / Date
Triggers
January 9th, 201403:49 PMUser / Points
You recieved 0 fromComment
No Comment Made
