Jak pobrac dane z bazy, z 2 tablic o takich samych nazwach pol,
Moj problem jest opisany tutaj http://algorytmy.pl/?id=2164 ale nie ma rozwiazania :/
moje tabele:

[SQL] pobierz, plaintext 
CREATE TABLE `mixtape` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artist` text NOT NULL,
`album` text NOT NULL,
`tracklista` text NOT NULL,
`opis` text NOT NULL,
`url` text NOT NULL,
`img` text NOT NULL,
`vip` int(8) NOT NULL DEFAULT '0',
`data` text NOT NULL,
`ocena` int(11) NOT NULL DEFAULT '0',
`ile_ocen` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;
 
 
 
CREATE TABLE `plyty` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artist` text NOT NULL,
`album` text NOT NULL,
`tracklista` text NOT NULL,
`opis` text NOT NULL,
`url` text NOT NULL,
`img` text NOT NULL,
`vip` int(8) NOT NULL DEFAULT '0',
`data` text NOT NULL,
`ocena` text NOT NULL,
`ile_ocen` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;
[SQL] pobierz, plaintext 

chce z tych tabel wyciagnac pola id, artist, album a potem je zapetlic i posortowac wedlug daty malejąco
Czy ktos moze napisac jak to zrobic ?
z gory thx... p0zdro

[SQL] pobierz, plaintext 
(SELECT `id`,`artist`,`album`,`data` FROM `mixtape`) UNION
(SELECT `id`,`artist`,`album`,`data` FROM `plyty`) ORDER BY `data` DESC
[SQL] pobierz, plaintext