I want to create an sql query that will return an xml result that contains two attributes in a single node that come from two different tables.
This is what I want the result to look like:
<plan id="1871" garage="left">
here's what I've tried but it returns two separate results:
SELECT planTitle as '@id' from
where planId = 1871
select garage as '@garage' from dbo.parcel_plans
for xml path ('region')