dpcatsat

[ID]
  NUMERO=1033
  NOMBRE=DPCATSAT
  DESCRIPCION=Modelos
  CONFIG=F
  SINGUL=Modelo
  APLICA=01
  PRIMARY_KEY=”
[END_ID]

[FIELDS]
  C001=CAT_CODIGO                            ,’C’,040,0,’PRIMARY KEY’,’Código’,0
  C002=CAT_CODMAR                            ,’C’,010,0,”,’Código de Marca’,0
  C003=CAT_DESCRI                            ,’C’,120,0,”,’Descripción’,0
[END_FIELDS]

[INNER_JOIN]
  SELECT CAT_DESCRI FROM DPCATSAT INNER JOIN DPINV ON CAT_CODIGO=INV_CODSAT
[END_INNER_JOIN]

[OPTIONS]
[END_OPTIONS]

[COMENTARIOS]
  C: CHAR
  D: DATE
  L: LOGICAL 1=T 0=F
  N: NUMERICO
  M: MEMO

[SQL]
  SELECT <CAMPOS> FROM <TABLA>
  INNER JOIN XTABLA ON XCAMPO=YCAMPO
[ENDSQL]