Generate SQL INNER JOIN AND OUTER JOIN in the FROM clause

general discussion
1

Hi,
Could some one please suggest me How to generate the SQL INNER JOIN AND OUTER JOIN in the FROM clause in BO. we are using MS SQL SERVER 2000.

eg)
BO generates SQL in WHERE clause
TableNameONE.ID *= TableNameTWO.ID

I want BO to generate SQL in FROM clause.
dbo.TableNameONE LEFT OUTER JOIN dbo.TableNameTWO
ON TableNameONE.ID = TableNameTWO.ID

eg)
BO generates SQL in WHERE clause
TableNameONE.ID = TableNameTWO.ID

I want BO to generate SQL in FROM clause.
dbo.TableNameONE INNER JOIN dbo.TableNameTWO
ON TableNameONE.ID = TableNameTWO.ID

Thanks
Leo

Leo :us: (BOB member since 2004-01-07)

2

The INNER JOIN syntax is just an alternative for the equi-join ‘=’, the outer join syntax is created by BO itself by changing the relationships between tables from 'normal’joins to ‘outer’ joins in the specific universe.

Preferably you should solve this with BO designer …

blom0344 :netherlands: (BOB member since 2002-09-04)

3

You need to edit your prm file.

See here.

https://bobj-board.org/t/19226/3

Scott Bowers :us: (BOB member since 2002-09-30)

4

Thanks for your suggestion Scott ,
I will edit the prm file and get back to you.

Thanks Ties Blom for your response, actually I am looking to change it to SQL-92 syntax not setting the joins in universe.

Thanks
Leo

Leo :us: (BOB member since 2004-01-07)