09-10-2007 11:32 AM
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.
09-10-2007 11:39 AM
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.
09-10-2007 11:35 AM
it is must to use inner join with the above statement as far as i know.
09-10-2007 11:37 AM
Hi,
Otherwise u can used select for all entries instate of join .
Regards,
Nihar Swain .
09-10-2007 11:37 AM
Hello,
U need to use JOIN for multiple table selection. INNER JOIN.
Regards,
LIJO
09-10-2007 11:39 AM
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.