topic Re: joins in Application Development and Automation Discussions

joins

Former Member — Thu, 26 Jul 2007 04:26:21 GMT

how can i fetch data from 3 tables with a single select statement without using joins

Re: joins

Former Member — Thu, 26 Jul 2007 04:28:17 GMT

create a datbase view in se11 with those three tables and now select the data by using single select statement from that view.

regards

shiba dutta

Re: joins

Former Member — Thu, 26 Jul 2007 04:28:20 GMT

hi Samuel,

Create a database view with all the three tables via SE11 and use that view in your select statement

Regards,

Santosh

Re: joins

Former Member — Thu, 26 Jul 2007 04:45:34 GMT

hi,

Use Database View (SE11)

Database views are implement an inner join, that is,

only records of the primary table (selected via the join operation)

for which the corresponding records of the secondary tables also exist are fetched.

Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields.

In the other types of view, they must be taken from existing foreign keys.

That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

Creating Database View:

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm

Regards

Reshma

Re: joins

Former Member — Thu, 26 Jul 2007 04:47:32 GMT

Hi Samuel

Create a database view(SE11) and select those particular fields from the 3 tables and use select statement from the view

if it is helpful please reward points,

Regards,

Azhar

Re: joins

Former Member — Thu, 26 Jul 2007 04:54:25 GMT

hi,

u can use view for it for even for all entries statement.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: joins

Former Member — Thu, 26 Jul 2007 05:02:30 GMT

Hi Samuel,

There is a just workaround for it and it is also internally a JOIN :).

You need to create a DB view on there 3 tables.

Regards,

Atish

Re: joins

Former Member — Thu, 26 Jul 2007 05:04:06 GMT

bu the view also contains joins is there no other way to do it

Re: joins

Former Member — Thu, 26 Jul 2007 05:05:41 GMT

hi Samuel,

I guess this is the only way as per your requirement .....

Regards,

Santosh

Re: joins

Former Member — Thu, 26 Jul 2007 05:05:53 GMT

Hi samuel,

I already answered your query

No there is no other way to get data from 3 tables in one select statement.

Regards,

Atish

Re: joins

Former Member — Thu, 26 Jul 2007 05:07:47 GMT

thank for u r answer

Re: joins

Former Member — Thu, 26 Jul 2007 05:09:01 GMT

samuel

u create a view and use it as a single table

if ur view is view1

then use

select * from view1.

i think they is no other way for ur requirement

Regards,

Azhar

Re: joins

Former Member — Thu, 26 Jul 2007 05:12:09 GMT

Hi Samuel,

The only way is to create a projection view of 3 database tables and slect records from that VIEW.

regards

Debjani