Got a help from a colleague, it is something like this.

Thanks anyway.

Select CODE ,[DESC] as subDepart,

(Select [DESC] from dbo.CUSTOMER as c1 where c1.LEVEL1 = c.LEVEL1 and c1.LEVEL = 1...

The indention of each column is not taken when i post it, I have added a comma seperator so you can copy and paste, and save it as CSV to...

Sorry Sandy, it works properly. The total column has been changed with NULL values after i have executed a stored procedure which add a new row.

insert into tableX (date, col1, col2, col3, col4, total)

select date, col1, col2, col3, col4, total

from tableY

tableX :

date, col1, col2, col3, col4, col5, col6, total

tableY :

date, col1, col2, col3, col4,...

One more thing, the total column shows NULL values as

tableX has more columns then tableY.

Thanks Sandy. It works.

Thanks Mr Suresh, it works.

Thanks also Mr GSquared, shall i just copy paste that query?

Sir the number should show only 1 row which has latest date.

6469482 should show only 1.

6469482 MariaC ...

Sorry Mr tertiusdp and Mr raja_saminathan but both queries don't work.

Mr tertiusdp - the query shows an error when i run it.

Mr raja_saminathan - the query will only show...

Mr Mahesh, please check the names as there are different names

Ok thank you very much... i need to know these joins

Entries ...