#1060 - Duplicate column name 'city' error in creting view for phpmyadmin

[Spraban9]

create view alltable as SELECT cr.city,cr.address,cr.description,cr.contact,cr.postdate,cs.city,cs.address,cs.description,cs.contact,cs.postdate,la.city,la.address,la.description,la.contact,la.postdate,ho.city,ho.address,ho.description,ho.contact,ho.postdate from computerrepair as cr,computersale as cs, land  as la,house  as ho where cr.postdate =cs.postdate and cs.postdate=la.postdate and la.postdate=ho.postdate and cr.postdate='2013-03-26'

hi friends

i create view for get data in order to postdate

but this coding show below error.

#1060 - Duplicate column name 'city'

how to solve this problem friends

[mikosiko]

use aliases to differentiate columns with the same name in each table... like : cs.city AS cscity  or whatever alias that you like the most....