topic Re: open sql - multiple tables in FROM in Application Development and Automation Discussions

open sql - multiple tables in FROM

Former Member — Mon, 10 Sep 2007 10:32:02 GMT

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,

Former Member — Mon, 10 Sep 2007 10:35:44 GMT

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

Former Member — Mon, 10 Sep 2007 10:37:23 GMT

Hi,

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

Regards,

Nihar Swain .

Former Member — Mon, 10 Sep 2007 10:37:32 GMT

Hello,

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

Regards,

LIJO

Former Member — Mon, 10 Sep 2007 10:39:15 GMT

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.