as with natural join code example Example: natural join query in mysql SELECT id,aval1,cval1 FROM table111 NATURAL JOIN table113;