# API - SQL - Query with relations not working

**URL:** <https://forum.seatable.com/t/api-sql-query-with-relations-not-working/6994>\
**Category:** API\
**Tags:** sql-query\
**Created:** [September 26, 2025, 12:54pm UTC](https://forum.seatable.com/t/api-sql-query-with-relations-not-working/6994 "2025-09-26T12:54:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![smmi](https://forum.seatable.com/letter_avatar_proxy/v4/letter/s/d6d6ee/32.png) [@smmi](https://forum.seatable.com/u/smmi)\
**Post date:** [September 26, 2025, 12:54pm UTC](https://forum.seatable.com/t/api-sql-query-with-relations-not-working/6994/1 "2025-09-26T12:54:35Z")

</div>

Hello,

I try to get datas with the PHP API Client.

Query = “SELECT \* FROM `Devis` AS devis,  
`Affaires` AS affaire,  
`Sociétés` AS societe,  
`Contacts` AS contact  
WHERE devis.affaire\_id = affaire.id AND devis.societe\_id = societe.id AND devis.contact\_id = contact.id AND devis.id = ‘$devis’ ”

This query works fine on Seatable Cloud with JS Script (To test).

Simple query works fine with PHP Client but associated request return results empty.

Any ideas ?

Thanks.