I have two tables, *a* and *b*:

```
+-------------+--------+-----------+
| ID_do_aluno | Nome   | Sobrenome |
+-------------+--------+-----------+
|   154676754 | John   | Brown     |
|   232565690 | George | Yellow    |
|   345896580 | Anne   | Green     |
|   459986789 | Ted    | Purple    |
+-------------+--------+-----------+

```

```
+-------------+--------+-----------+
| ID_do_aluno | Nome   | Sobrenome |
+-------------+--------+-----------+
|   154676754 | John   | Brown     |
|   232565690 | George | Yellow    |
|   342889999 | Rich   | White     |
+-------------+--------+-----------+

```

Im trying to get their intersection. I tried

```
(select * a)INTERSECT(select * from b);

```

and many other variations, but couldnt get it right.
What I need is

```
+-------------+--------+-----------+
| ID_do_aluno | Nome   | Sobrenome |
+-------------+--------+-----------+
|   154676754 | John   | Brown     |
|   232565690 | George | Yellow    |
+-------------+--------+-----------+

```

Thanks in advance, sorry for the begginer's difficulty to locate this well-discussed subject in foruns & documentation!