Simple queries

sshilderman

I'm all new to Rapidminer, and having troubles with basic stuff.
I want to make a query on two tables (example sets) at a time, and cross the data.

I can write a SQL statement, but i can't find a away to show it at the results page (if it's possible).

How can i do that both ways?

Thanks.

earmijo

Use the operator JOIN.

If you give me more details, I can be more specific.

sshilderman

I'm using Join as you said.

Is there a way to use the Execute SQL operator and show the result on Rapidminer? and keep working with the data?

thanks.

MartinLiebig

Hi,

have you tried Read Database? You can write custom sql there as well.

~Martin

sshilderman

Didn't know the Read Database supports it.
It is definitely what i needed.

Thanks a lot!