select t2.tableName as 'Table Name',convert(varchar,t2.gametype) as 'Limit',Convert(varchar,Convert(numeric(18,2),t2.smallblind))
+ '/' + Convert(varchar,Convert(numeric(18,2),t2.bigblind)) as 'Stakes',t3.GameName as 'Game Name'
from tblgameinfo t1 join tblGameTables t2 on (t1.tableid=t2.tableid) join tblGames t3 on (t3.gameid = t1.gameid)
where (t2.skinid= 6 or t2.skinid= 0) and t1.nickname = 'Player1'
union all
Select t2.tablename as'Table Name',convert(varchar,t1.TableID) as 'Limit',convert(varchar,t1.TournamentID) as 'Stakes',t3.TournamentName'Game Name'
from tblRegistration t1 join tblGameTables_TRMNT t2 on t1.TableID=t2.TableID join tblTournaments t3 on t3.tournamentID=t1.TournamentID
where t3.skinid= 6 and t1.nickname='Player1' AND t1.Eliminated='N' and t1.TableID >-1 and t3.State='P' and t3.TournamentType='S'
Atully what we have to do there, where as second column of both queries was in with different datatypes.! so we have to also converted them as well other columns also..! thank you digimanus sir and all of u guyies..! its works now! this code is now updated..!