Hi,

I'm not sure if this would help in your quest for the answer but

If you create a temporary table of distinct values of columnA then use this in your select with the rownum <=3.

eg

create table temp_tab as (select distinct(columnA) from t1;

select t1.columnA, t2.columnB
from t1, t2
where t1.columnA in
(select columnA from temp_tab where rownum <=3)
and
......

In your example it will return the following

Atlanta ----Chris
Florida ----Phil
L.A -----Boris
L.A -----David
L.A -----Jenny
L.A -----Joseph

(It sorts it into order when you create the temp table using select distinct)

Hope this helps.

If not I'd be interested to see how the problem is solved. I'd appreciate it if you could E-Mail the solution to [email protected] - It's got me a little bugged on how you can get the exact result you asked for - unsorted.

Kind Regards

Moff