How do make columnname from one table as a tablename in sql join

44 Views Asked by At

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

0

There are 0 best solutions below