How can I transform this IMPLICIT query into EXPLICIT query?

arbab · February 21st, 2011, 03:10 AM

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

om_prakash · February 21st, 2011, 09:52 AM

Code:

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;

debasisdas · April 8th, 2011, 06:43 AM

Officially there is no term called IMPLICIT query or EXPLICIT query.

These terms are used for cursors not for query.

I think what you are trying to do is convert a query written in conventional SQL into ANSI SQL.

arbab · April 11th, 2011, 05:21 AM

@debasisdas: Thanks for your correction: I was expressing the query which uses keyword of INNER JOIN or something as IMPLICIT and those which do not as EXPLICIT, what can be the proper name for them?
&
Transforming the following query in a query which has INNER JOIN mentioned in it?
Select A1.Account_type,A1.Title, A2.Channel_id,A2.Account_type
from Tblaccount A1, Tblcustchannelacct A2
where A1.Account_type = A2.Account_type;

The above query is working fine; I transformed the above query into this query as, now using KEYWORD of INNER JOIN
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

joefawcett · April 11th, 2011, 05:45 AM

I haven't worked with Oracle for a few years but with SQL Server the syntax would be:

Code:

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;

debasisdas · April 12th, 2011, 12:33 AM

The error is because you are trying to join 3 tables and the 3rd table is not joined to anything.

Post the table structures to get proper query.