Hi. I have a query which works and is quick, but it misses a couple of
records.
SELECT ArgumentCalendar.Docket
, ArgumentCalendar.Date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Preview.Blurb
FROM ArgumentCalendar
, CaseID
, Parties
, Preview
WHERE CaseID.DocketNumber =
Try this one:
SELECT STRAIGHT_JOIN ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM ArgumentCalendar
, CaseID
, Parties
LEFT JOIN Preview ON
Does this help?
SELECT
ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM
ArgumentCalendar
, CaseID
,
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
there after the SELECT.
But it doesn't get me anything. EXPLAIN still says I am examining all
19,701 rows in CaseID: same problem as before.
- BLH
At 10:46 AM 1/25/2001 -0800, you wrote:
Try this one:
SELECT
Thanks, but not really. I wish to get all the cases, even when there is no
Blurb in Preview. Your query only grabs cases where the Blurb in Preview
is missing by adding WHERE Preview.CASEID IS NULL. - Brian
- BLH
At 01:00 PM 1/25/2001 -0600, you wrote:
Does this help?
SELECT
Send the results of the EXPLAIN
On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote:
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
there after the SELECT.
But it doesn't get me anything. EXPLAIN still says I am examining all
19,701 rows in CaseID: same problem
At 01:19 PM 1/25/2001 -0800, Ryan Wahle wrote:
Send the results of the EXPLAIN
table type possible_keys key key_len ref rows Extra
ArgumentCalendar ALL Date [none] [none] [none] 63 where used
CaseID ALL PRIMARY [none] [none] [none] 19701 where used
Parties eq_ref PRIMARY PRIMARY 4 CaseID.CASEID