Rediks "SELECT *, u.no AS uNo, u.ad AS uAd, u.ikon AS uIkon, u.tarih AS uTarih,
l.no AS lNo, l.tarih AS lTarih, l.ikon AS lIkon, l.ad AS lAd
FROM tablo1 AS u JOIN tablo2 AS l
UNION ALL
SELECT *, u.no AS uNo, u.ad AS uAd, u.ikon AS uIkon, u.tarih AS uTarih,
l.no AS lNo, l.tarih AS lTarih, l.ikon AS lIkon, l.ad AS lAd
FROM tablo1 AS u JOIN tablo2 AS l ORDER BY uTarih,lTarih DESC");