Question: I have an query related to straight join the query is correct but showing error

```
SELECT table112.id,table112.bval1,table112.bval2,  
table111.id,table111.aval1  
FROM table112  
STRAIGHT_JOIN table111; 

```

Showing an error can anybody help out this

Answer: 
There is missing the join condition.

```
SELECT table112.id,table112.bval1,table112.bval2,
table111.id,table111.aval1
FROM table112
STRAIGHT_JOIN table111 ON table112.id = table111.id

```
```
SELECT table112.id, table112.bval1, table112.bval2, table111.id,table111.aval1 FROM table112

```

That is not a join

```
Select * from table112 join table111 ON table112.id = table111.id

```

That is how a join works.

What are you trying to do? I might be able to help more than.