Witam,
Panowie mam problem z full join - nie wiem czemu otrzymuje błąd 1054?
mysql> select imie,nazwisko,miasto,stanowisko,wiek,zarobki,samochod
-> from daneosobowe full join daneosobowe2
-> on daneosobowe.wiekid=daneosobowe2.id;
ERROR 1054 (42S22): Unknown column 'daneosobowe.wiekid' in 'on clause'
mysql> show columns from daneosobowe;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| Imie | varchar(20) | YES | | NULL | |
| Nazwisko | varchar(20) | YES | | NULL | |
| Miasto | varchar(20) | YES | | NULL | |
| Stanowisko | varchar(20) | YES | | NULL | |
| Zarobki | decimal(7,1) | YES | | NULL | |
| wiekid | int(20) | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql> show columns from daneosobowe2;
+----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| Wiek | int(2) | YES | | NULL | |
| samochod | varchar(3) | YES | | NULL | |
+----------+------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql>
Ktoś pomoże?