how to write a single select query for selecting two table columns?

See more:

SQL-Server

hi sir,

i am taking two tables i.e., table1 and table2. if i execute table1 result is

Select * from table1

Name    class

Ajay	  8
raju	  9
Surya	  7
ajay raju 10 

and execute table2

select * from table2

Dept       Gen

Accounts    M
Management  F
Research    M
Developing  M
designing   M

i want to take dept column from table2

that i write query like

select dbo.table1.name,dbo.table1.ID,dbo.table2.dept from table1,table2

Then result is:

Name   ID       Dept

Ajay	    8	Accounts
Ajay	    8	Management
Ajay	    8	Research
Ajay 	    8	Developing
Ajay	    8	designing
Raju	    9	Accounts
Raju	    9	Management
Raju	    9	Research
Raju	    9	Developing
Raju	    9	designing
Surya	    7	Accounts
Surya	    7	Management
Surya	    7	Research
Surya	    7	Developing
Surya	    7	designing
Ajay raju   10	Accounts
Ajay raju   10	Management
Ajay raju   10	Research
Ajay raju   10	Developing
Ajay raju   10	designing

this time it display result as number of times.

but my aim is result display like:

Name      ID       Dept

Ajay	  8    Accounts  
raju      9    Management     
Surya     7    Research 
ajay raju 10   Developing
null     null  designing 

Please give a solution. and please give a sample select query for this

Thank you sir.