select on joined tables

select on joined tables

For some reason I am able to execute the following join statement

select * from "t_actionsheader" join "t_actions" on "t_actionsheader"."Actionid" = "t_actions"."ID"

But I can't save it.

Has anyone tried a join of 1:n table relationships before?