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
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.
TIA
Nanu
