How to get emp id, sal, date from 2 tables ?

Posted by Kk86kiran under Sql Server on 4/17/2012 | Points: 10 | Views : 1691 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi friends,

I have already asked this question for 1 table but this time i am asking for 2 tables Means i have 2 tables January & February with same column names those are empid,sal,date.

Now i want to show out put like this

[Empid] [No.ofEmpid] [TotalSal] [No.OfMonths]

1 2times 12000 2Months
2 2times 20000 2Months
3 2times 10000 2months

k.m.j.kiran

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Hariinakoti on: 4/17/2012 [Member] Starter | Points: 25

0	Hi Kiran, If u have common fields in both tables u can use join query. http://www.w3schools.com/sql/sql_join.asp Thanks & Regards Hari Thanks & Regards Hari Kk86kiran, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jasminej on: 4/18/2012 [Member] Starter | Points: 25

0	Can you give Table structure with data ? Kk86kiran, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts