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 =
in separate tables with a person-key linking rows in these
tables to rows in the person table in a one-to-one relationship.
This assumes these 248 piece of data have some logical internal structure
that would group them into sets that could describe some entity.
My 2 cents.
- Brian Hughes
CaseID.DocketNumber = ArgumentCalendar.Docket
AND Parties.CASEID = CaseID.CASEID
AND '20010125' = ArgumentCalendar.Date
On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote:
Hi. I have a query which works and is quick, but it misses a couple of
records.
SELECT ArgumentCalendar.Docket
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
1 [none]
Preview ALL [none] [none] [none] [none] 150 [none]
(blank cells indicated by [none])
- BLH
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