topic Re: Select count (*) in Application Development and Automation Discussions

Select count (*)

Former Member — Wed, 14 Mar 2007 23:37:03 GMT

Hi all,

I have got 3 tables to select data from, how can I join them, and also need to check a field on each table,get the total count of the records!

Regards,

Bharat

sudhindra_chandrashekar — Thu, 15 Mar 2007 00:13:28 GMT

Hi,

Use this to get used to joins:

To get the total count of the records you can use the system field SY-TABIX.

Hpoe this helps,

Sudhi

Former Member — Thu, 15 Mar 2007 01:45:48 GMT

Here is how you Join 3 tables.

MARA. MAKT, MARC are the tables to join.

select a_{matnr b}aedat b_{maktx c}werks

from ( mara as a inner join makt as b

on b_{matnr = a}matnr )

inner join marc as c

on c_{matnr = a}matnr

into table itab.

For joining more than two tables, the result set of a join of two tables has to be joined to the third and the same continues for more tables.

To get the total number of records of field, you can use the System defined data object SY-DBCNT after the select statement.

former_member194669 — Thu, 15 Mar 2007 01:57:06 GMT

If you have proper key for select then go for join

other wise

make 3 separate select and

use describe command to count.

aRs

Former Member — Thu, 15 Mar 2007 21:39:22 GMT

Thats done. Thanks for all inputs.