Bhuvnesh (11/14/2013)
mpradeep23 (11/13/2013)
how do i join tables with out joinsYou can .... for that you have to do table level changes like merging two tables (which contains parent-child relationship or similar kind of data).
and that process is known as denormalization.
and it's usually a bad idea.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability