Hi

Need little help here, trying to write an SQL that do as follows

have two tables and when I join them I would get something like

Column A---Column B
New York----David
New York----John
New York----Alex
Atlanta-------Chris
Florida-------Phil
L.A-----------David
L.A-----------Jenny
L.A-----------Boris
L.A-----------Joseph
Miami--------Alex
Miami--------Will

Now I want the query to return just a limited rows using rownum, for example

where rownum <= 3

However this would return

Column A---Column B
New York----David
New York----John
New York----Alex

ONLY

But I need all results of first column <= 3, what i am saying is that I need the query to return me

Column A---Column B
New York----David
New York----John
New York----Alex
Atlanta-------Chris
Florida-------Phil

where column A has 3 values

is this possible at all? I have seek a few ways but cant do it!!!

Cheers