Hello,
I’m wondering if it’s possible to force a second join to a table. For example: paintings.name like A% AND paintings.name like G% In a SQL query, this will always return 0 records because a given painting cannot start with the letter A and G at the same time. It either starts with one or the other. So if I’m looking for artists that have a painting with its name starting with the letter A and another one with the letter G then the SQL would have to do a second join. For example, SELECT * FROM ARTIST t0 JOIN PAINTING t1 ON t1.ARTIST_ID = t0.ID JOIN PAINTING t2 ON t2.ARTIST_ID = t0.ID WHERE t1.NAME LIKE ‘A%’ AND t2.NAME LIKE ‘G%’ Thanks in advance, Ricardo Parada
