topic SELECT * with JOIN statment in Application Development and Automation Discussions

SELECT * with JOIN statment

Former Member — Mon, 02 Nov 2009 11:37:55 GMT

Hi,

I'm joining two tables with SQL, the problem I want to write * from writing all the fields

what I do like this

SELECT Z_{* T}* FROM table1 AS Z INNER JOIN Tbale2 AS T ON Z_{x = T}y

how do I write this ?? without getting error for Z_{* and T}*

Thx

ThomasZloch — Mon, 02 Nov 2009 11:45:49 GMT

Just write SELECT * FROM ...

Thomas

Former Member — Mon, 02 Nov 2009 11:49:14 GMT

Hi,

If you want to use all fields of both tables use it as follows:-

TYPES:BEGIN OF ty_mat,

include TYPE mara.

INCLUDE TYPE makt.

types:END OF ty_mat.

data:t_mat type standard table of ty_mat.

then use select * from table1 and table 2 as your doing now.

Alternatively u can use this:-

SELECT * FROM X INTO TABLE T_TABLE1.

SELECT * FROM Y INTO TABLE T_TABLE2

FOR ALL ENTRIES IN T_tABLE1

WHERE p = T_TABLE1-Q.

Edited by: Subhashini K on Nov 2, 2009 5:25 PM