Skip to Content
0
Former Member
May 10, 2005 at 04:06 PM

Qry in JOINS

16 Views

Hi All,

Sorry if its very simple basic question .

Code:

tables:mara,makt.

data:t_mara type mara occurs 0.

select-options:s_mat for mara-matnr,

s_des for makt-maktx.

select amatnr amtart

into corresponding fields of table t_mara

from mara as a inner join makt as b

on amatnr eq bmatnr

where amatnr in s_mat and bmaktx in s_des.

Question :If i want to select all fields from mara table whats the easiest way ? why select * is not possible here .

Regards,

Jeeva