[Solved] sql server select statement for 3 tables using join [closed]

by

[ad_1]

how about this query :

select top 3 Package_Title, DurationInDays,Package_Image_1, Adult_Price , 
    STUFF((Select themes.theme + ',' From package_theme 
        inner join themes on themeid = package_theme.theme
        Where package_theme.package = packages.Package_ID FOR XML PATH('')),1,1,'')     As theme
from packages 
inner join  rates on rates.package = packages.Package_ID

5

[ad_2]

solved sql server select statement for 3 tables using join [closed]