how to do multi conditional join
i have sql query which search in two tables.city and country
the city come with two language and also the country
so i have 4 city coulmns City and ar_city ,country and a_country
because i have not expected what user use any lang so i use condition or
but i have sql error..so how to do this
select * FROM d_cities
WHERE City='algeria center'
OR ar_city='ÇáÌÒÇÆÑ ÇáÚÇÕãÉ ÇáÌÒÇÆÑ'
JOIN d_country
ON d_country.Country = 'algeria'
OR d_country.ar_country='ÃáÌÒÇÆÑ'
No comments:
Post a Comment