With Qlikview you don't need to specify the column names to join on, Qlikview will automatically join on common field names between the tables
if you still want to use your existing SQL statement then use a SQL SELECT clause as below for example
SQL SELECT Order, Item, Date
FROM TABLENAME WHERE <Your condition>
If I correctly understood the code Oracle (I'm not an specialist in Oracle, the Internet is in the help).
Source code Oracle looks something like this
select * from TABLE1 "table1", TABLE2 "table2"
table1.column = table2.column(+)
and table1.column = table3.column(+)
The same code of Qlik script (tables сonsider as internal) will be like this
Left Join (Table)
You can not use directly this (above) expression in Qlik.