Thread

Inexperienced with SQL queries - have come to understand how the following queries work separately, but how to make them work together to display desired result? Thank you, anyone.

{exp:query sql="SELECT m_field_id_4, m_field_id_2 FROM exp_member_data"}{exp:query sql="SELECT screen_name FROM exp_members WHERE group_id = '5'"}

{m_field_id_4} {m_field_id_2} {screen_name}

{/exp:query}

How about this:

{exp:query sql="SELECT a.screen_name, a.group_id, b.m_field_id_4 AS field4, b.m_field_id_2 AS field2 FROM exp_member_data FROM exp_members AS a, exp_member_data AS b WHERE a.group_id = '5'"}

{field4} - {field2} - {screen_name}


{/exp:query}

Thank you, Ronny - thank you, ExpressionEngineer. I have a lot to learn - but needed a solution right away and ExpressionEngine’s solution worked great ...thank you.

You’re welcome, one is glad to have been of service! 😊