Transforming the following IMPLICIT query into EXPLICIT query?
Select A1.Account_type,A1.Title, A2.Channel_id,A2.Account_type
from Tblaccount A1, Tblcustchannelacct A2
where A1.Account_type = A2.Account_type;
How can I transform the above IMPLICIT query into EXPLICIT query? The above query is working fine; I transformed the above query into EXPLICIT query as
Select A1.Account_type,A1.Title, A2.Channel_id,A2.Account_type
from Tblaccount A1, Tblcustchannelacct A2
INNER JOIN Account_type
on A1.Account_type = A2.Account_type;
this query is giving error of 'Table or View does not exist'. Can you guide me with this?
Thanks in advance
Amit ChoudharyPosted Feb 21, 2011, 3:04 AM
Select A1.Account_type,A1.Title, A2.Channel_id,A2.Account_type
from Tblaccount A1
INNER JOIN Tblcustchannelacct A2
on A1.Account_type = A2.Account_type;
Try this i have removed the error you have use the column name in place of table name.
Please mark "Do you like this answer" if it helps you.
Thanks