Comments by Member 10190046 (Top 1 by date)

SELECT row_number()over (order by Author_name asc)as'SNo',
autdeta.unique_id,Author_name,phone,address,email,AuthRecordID, (select distinct Author_name from autdeta
)
FROM autdeta
inner join booksdeta
ON autdeta.unique_id = booksdeta.AuthRecordID
--order by autdeta.Author_name ASC
select * from autdeta





error shows blow
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.