SQL query to fetch list of records in subquery -

how write query fetch record this,

i have 2 tables mentioned below,

now, want fetch record 1 row - list of column dtls below query

select a.id id, a.row_no row_no, b.* b a, b b

please me fetch records based on requirement.

use left join or inner join (see links documentation)

select i.id id, i.row_no row_no, j.* j  left join b j  on i.row_no = j.row_no

btw query easier readable if don't use capital letters in table structure

RT