Issue With Inner Join

[likelylad]

I am trying to run the following code:

select h.Header_ID,h.Order_Number,h.Order_Type_ID,l.Line_Number from table1 l Inner Join table2 h on l.Header_ID=h.Header_ID where l.Header_ID=1234567;

but it is giving me the following error
ORA-00933 SQL Command Not Properly Ended

Also I tried the following

select h.Header_ID,h.Order_Number,h.Order_Type_ID,l.Line_Number from table1 h,table2 l Where l.Header_ID=1234567;

I was only expecting 4 records (as there are only 4 records in l.Header_ID) but it is giving thousands of records.

Thanking in advance for any help received.

 

[likelylad]

Sorry figured it out:

select h.Header_ID,h.Order_Number,h.Order_Type_ID,l.Line_Number from table1 h,table2 l Where h.Header_ID=l.Header_ID And l.Header_ID=1234567;