sql - Written a subquery that can return more than one field without using the Exists -

the query below supposed pull records fields max date.

i getting error

you have written subquery can return more 1 field without using exists reserved word in main query's clause. revise select statement of subquery request 1 column.

code:

select * tablename (((([project_name], [date])) in (select project_name, max(date)                                         tablename                                         group project))); 

your thinking of nested subquery used table, below:

select a.*, b.1, b.2 firsttable join (select id, firstcolumn 1, secondcolumn 2   secondtable) b on b.id = a.id 

works pretty regular join except using subquery. hope helps,