Thanks for your response. However, could you give the exact code to place in my query so the data that my query is pulling will only provide it by the current user? I have tried but to no avail.

thanks

Provide structure jos_facileforms_records and jos_facileforms_subrecords tables please.

Regards,
ARI Soft

Here ya go.

Code
------------------------------------------------------------------------------------
SELECT jos_facileforms_subrecords.name, jos_facileforms_subrecords.value, jos_facileforms_records.id
FROM jos_facileforms_subrecords
LEFT JOIN jos_facileforms_records ON jos_facileforms_subrecords.record = jos_facileforms_records.id
WHERE jos_facileforms_subrecords.title IN ('Project Title')
ORDER BY jos_facileforms_subrecords.id

-------------------------------------------------------------------------------------

thank you in advance for your help!

Provide structure of the tables, not your SQL query. We need to know what columns contains the tables.

Regards,
ARI Soft

Hi,

I re-read your email requesting the structure. I have attached that information.

Thank you. Use the next SQL query:



Regards,
ARI Soft