Coder Forum

SQL Code

CREATE TABLE tabelle1 (
  id int(11) NOT NULL AUTO_INCREMENT,
  wert1 int(11) NOT NULL,
  wert2 int(11) NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;
 
INSERT INTO tabelle1 (id, wert1, wert2) VALUES 
(1, 1, 2),
(2, 2, 1);
 
CREATE TABLE tabelle2 (
  id int(11) NOT NULL AUTO_INCREMENT,
  wert1 int(11) UNSIGNED NOT NULL,
  wert2 int(11) UNSIGNED NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM;
 
INSERT INTO tabelle2 (id, wert1, wert2) VALUES 
(1, 1, 2),
(2, 2, 1);

SQL Code

SELECT ABS(a.wert1-b.wert2) FROM tabelle1 a JOIN tabelle2 b ON a.id = b.id;
+----------------------+
| val                  |
+----------------------+
| 18446744073709551615 | 
|                    1 | 
+----------------------+
2 rows IN SET (0.00 sec)

SQL Code

SELECT IF(a.wert1>b.wert2,a.wert1-b.wert2,b.wert2-a.wert1) FROM tabelle1 a JOIN tabelle2 b ON a.id = b.id;