Select multiple tables

[Dung Trinh]

Hi,
I have 2 tables that are very similar. Each table has the field 'house_num'. I want to query from those 2 tables all rows that house_num=165 and below is my query

Select * from table1 As A, table2 As B where A.house_num='165' AND B.house_num='165';

What I've got is 5 rows from table1 and 1 row from table2, that's correct but the problem is that they are not listed sequentially, instead they are combined together as for each row of table1 there's 1 row of table 2 followed right after as:

ROW1TABLE1+ROW1TABLE2
ROW2TABLE1+ROW1TABLE2
ROW3TABLE1+ROW1TABLE2
ROW4TABLE1+ROW1TABLE2
ROW5TABLE1+ROW1TABLE2

What I want to see should be

ROW1TABLE1
ROW2TABLE1
ROW3TABLE1
ROW4TABLE1
ROW5TABLE1
ROW1TABLE2

I cannot use UNION because my MYSQL version is 3.29 I cannot update it now. I'm really appreciated for any help. Thanks