Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

open sql - multiple tables in FROM

Former Member
0 Kudos

Hello,

Is it possible to do the following in open SQL:

select a~somefield from tableA as a, tableB as B

where akeyfield = bkeyfield.

Or is it a must to use joins when selecting date from multiple tables?

Kind regards,

J.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Joren,

1. This kind of syntax is fine in oracle.

2. But when we use Open Sql,

it will give error.

We necessarily have to use the INNER JOIN wordings in the syntax.

regards,

amit m.

4 REPLIES 4

Former Member
0 Kudos

it is must to use inner join with the above statement as far as i know.

Former Member
0 Kudos

Hi,

Otherwise u can used select for all entries instate of join .

Regards,

Nihar Swain .

Former Member
0 Kudos

Hello,

U need to use JOIN for multiple table selection. INNER JOIN.

Regards,

LIJO

Former Member
0 Kudos

Hi Joren,

1. This kind of syntax is fine in oracle.

2. But when we use Open Sql,

it will give error.

We necessarily have to use the INNER JOIN wordings in the syntax.

regards,

amit m.