Nanu Kalmanovitz wrote:
Hi!
System is Novell SBS 6.5 sp1 with Apache 2.0.48, MySQL ver. 4.0.15a,
PHP 4.2.3.
We try to define a select query that takes the values of the variables
'varKoshi' and 'varKvish' based on the following 4 tables:
'varKoshi' >>>>>>>>>>>>>>v v<<< 'varKvish'
v v
Table1: access_diff v v Table4: tracks
---------------------- v v
-------------------
access_diff.DiffLevel <<<<<<< >>> tracks.Kvish_Access
access_diff.Access_ID v<< tracks.Track_ID
v v
v Table2: accesses v
v -------------------- v
>> accesses.Access_ID v
accesses.Track_ID <<
v<< accesses.Site_ID
v
v Table3: sites
v -------------
>>> sites.Site_ID
sites.Site_Short_Description >>> RESULTS
Your graphic is garbled. Did you perhaps not use a fixed width type font
to compose it?
We want to find all records that:
A. 1. 'varKoshi' = access_diff.DiffLevel (Table1)
2. access_diff.Access_ID (Table1) = access_diff.Access_ID
(Table2)
B. 1. 'varKvish' = tracks.Kvish_Access (Table4)
2. tracks.Track_ID (Table4) = accesses.Track_ID (Table2)
C. The common values for accesses.Site_ID (Table2) from A and B are
equal to the values in sites.Site_ID (Table3) to retrieve the
corresponding records in the sites.Site_Short_Description
Table3)
as the RESULTS.
The query we did is:
SELECT sites.Site_Short_Description
FROM sites, accesses, access_diff, tracks
WHERE access_diff.DiffLevel = 'varKoshi'
and accesses.Access_ID = access_diff.Access_ID
and tracks.Kvish_Access = 'varKvish'
and accesses.Track_ID = tracks.Track_ID
and sites.Site_ID = accesses.Site_ID
The problem is that not every time all the correct records
(possibilities) are found.
Your query looks good to me. The problem must be bad data.
--John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]