select *,
(
	select *
	from dbo.sales s
	where s.clientid = c.clientid
	for xml path ('Sale'), type
) as Sales,
(
	select *
	from dbo.vendor
	for xml path ('Vendor'), type
) 
from dbo.clients c
for xml path ('Clients'), root ('ClientOrders')