chk t query
-
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on e.themeid=t.themeid and e.empguid=@sessionvalue is tis query correct after joins ... is it possible to use and join condition tanx
-
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on e.themeid=t.themeid and e.empguid=@sessionvalue is tis query correct after joins ... is it possible to use and join condition tanx
anbusenthil wrote:
is tis query correct after joins ...
This is not database forum.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on e.themeid=t.themeid and e.empguid=@sessionvalue is tis query correct after joins ... is it possible to use and join condition tanx
anbusenthil wrote:
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on e.themeid=t.themeid and e.empguid=@sessionvalue is tis query correct after joins ... is it possible to use and join condition
is tis query correct after joins ... is it possible to use and join condition First of all this is ASP.Net Forum and This is your repost. While asking problem regarding the same post then continue with that thread itself rather than post a new question. I believe you are using SQL Server to run your query. So what is the output for that statement ?
cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net
-
select @themeid=t.themeid,@themename=t.th_name from emptheme e left outer join themesetting t on e.themeid=t.themeid and e.empguid=@sessionvalue is tis query correct after joins ... is it possible to use and join condition tanx
anbusenthil wrote:
is tis query correct after joins ...
It depends on what you want it to show and what your data model is... How're we supposed to know. If you want to know if it's syntactically correct, why don't you run it...