i have 2 tables . column of one table is part of tablename to others , i want to make join in between these tables something like below.
select ar.id,ar.type from Art ar ,CONCAT('MOK', ar.type) mo where mo.id= ar.id
There is same id present in both table but mo.id does not exist is the exception i m getting.thnx for your time. name of second table is MOKdance
where dance =ar.type