open sql - multiple tables in FROM

[Former Member]

Hello,

Is it possible to do the following in open SQL:

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

where a_{keyfield = b}keyfield.

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

Kind regards,

J.

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Nihar Swain .

[Former Member]

Hello,

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

Regards,

LIJO

[Former Member]

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.