How to get LifecycleTemplate state

Hi,

how I can get the all lifecycle state name from lifecycletemplatemaster and lifecycletemplate right now I am running this query but it did not work for me, it just give me one lifecycle state name

select LifeCycleTemplateMaster.name, PhaseTemplate.name from lifecycletemplate, PhaseTemplate, LifeCycleTemplateMaster

where LifeCycleTemplateMaster.ida2a2 = lifecycletemplate.ida3masterreference and PhaseTemplate.ida2a2 = lifecycletemplate.ida3b9

and LifeCycleTemplateMaster.name = 'Action Item';