@SynopsisLabs can you share a visual image where you need the button ?
with SQL joins currently to click a button and open a detail page one way is to create a extra column in the query via CONCAT function like this
SELECT A, B, C,
CONCAT('https://mydomain.com/myproject-details-page?recordId=', project_id) as project_url
FROM ...
JOIN ...
WHERE ...
then you use action button with open external URL and put the project_url