join between two tables with composite keys

Mar 16, 2009 at 1:10 PM

Good morning.
How to make a join between two tables with composite keys, example

Select *
From PUBLICACOES
LEFT OUTER JOIN ESTADOS ON PUBLICACOES.IDESTADO = ESTADOS.IDESTADO AND PUBLICAÇOES.IDREGIAO = ESTADOS.IDREGIAO

no more

Coordinator
Mar 16, 2009 at 1:48 PM
This is not supported. You can just use SQL statement and DataSet.