valige * a inner join b peal a.a=b.b

The query select * from a inner join b on a.a=b.b performs an inner join between the two tables a and b based on the condition that the values of columns a.a and b.b are equal.

This means that in the result set, only the rows for which there are matching values in both tables in the specified columns will be included. If there is no matching row in b for a row in a, that row will not appear in the result.

Example:

a.a	a.other	b.b	b.other
1	x	1	y
2	z	3	w

The result will contain only the rows where a.a = b.b, i.e., for the value 1.