Hi All,

Need a help to solve the query, infact i am actually beginner to SQL.

Two tables one with Emp and other Address table. They look similiar to like this

Emp has two rows

Empid Ename

12 Scott
13 Tiger
14 Eagle


Address has two rows

Empid Add

12 Boston
13 Arizona
14 Boston

I need to list all the empid and ename whose address are same.


Thanks
regards
Prakash

Emp has two rows

Empid Ename

12 Scott
13 Tiger
14 Eagle

Here empid and ename are columns
In Emp table you have three rows and two columns.


The query is

Select a.empid, a.ename,b.add from emp a, address b
where a.empid = b.empid

I need to insert around 40000 rows into table. Is there any simple way for this? like using some for loop or while loop?

Dude this query would print all the rows since all employee ids wud be present in address table aganist to emp table

Just add one more line to the query given by me

and b.add in ( Here write query to return address having count(add)>1)

From where you are getting these 40000 rows?