Janusz,
Please see the attached screenshot. I get this error about 5 seconds after opening your spreadsheet.
SELECT
t2.AAAA t2.BBBB t2.CCCC t2.DDDD, t2.EEEE, t2.FFFF, t2.GGGG, t2.HHHH, t2.IIII, t2.JJJJ, t2.KKKK, t2.SrcID, t2.DestID, t1.ID, t1.AbbrevName as SourceIDAbbrev, t3.AbbrevName as DestIDAbbrev
FROM
Devices as t1, Channels as t2, Devices as t3
WHERE t2.SrcID = t1.ID and t2.DestID = t3.ID
SELECT Devices.ID as vID, Devices.AbbrevName as vAbbrevName FROM Devices
select * from Channels left join Devices on Channels.Source_ID = Devices.ID left join vDevices on Channels.Dest_ID = vDevices.vID
or with mysql command:
CREATE VIEW vDevices AS SELECT Devices.ID as vID, Devices.AbbrevName as vAbbrevName FROM Devices
CREATE VIEW Results AS select * from Channels left join Devices on Channels.Source_ID = Devices.ID left join vDevices on Channels.Dest_ID = vDevices.vID
select Channels.*, t1.AbbrevName as SourceIDAbbrev, t2.AbbrevName as DestIDAbbrev
from
Channels, Devices as t1, Devices as t2
WHERE
Channels.Source_ID=t1.ID and Channels.Dest_ID=t2.ID
[0] :
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'ID' in field list is ambiguous
===SQL===========
SELECT ID,Short_Name,Address,Units
from Channels, Devices as t1, Devices as t2
WHERE Channels.Source_ID=t1.ID and Channels.Dest_ID=t2.ID LIMIT 0, 20
===BACK TRACE====
/var/www/html/TestDB/nuform.php - line 898 (nuRunQuery)
/var/www/html/TestDB/nuform.php - line 324 (nuBrowseRows)
/var/www/html/TestDB/nuapi.php - line 42 (nuGetFormObject)