How to write a request

SELECT t2.* , (SELECT group_concat(ID) FROM Table1) as t1 FROM Table2 as t2 WHERE t2.ID = 1;

using api drupal7 .

    0