Hi i have 2 tables with one to many relationship, header to rows . my query look like this
SELECT HEADER_ID, ROW_ID, COL1,COL2 … ,
(SELECT MAX(row) where HEADER_ID = HEADER_ID)
FROM HEADER INNER JOIN ROWS ON …. WHERE …
WHAT IS THE BEST WAY (IF NEEDED) TO CHANGE THE SELECT MAX TO INNER JOIN
FROM
what will be