SELECT Societa FROM anagrafica Where IDSocieta = #url.IDSocieta# SELECT * FROM doc_tipo order by doc_tipo SELECT * FROM doc_formato order by doc_formato SELECT * FROM doc_pertinenza

Documenti a protocollo per "#soc.societa#"

SELECT p.*, dp.*, dt.*, df.* from (((protocollo p INNER JOIN doc_pertinenza dp ON dp.ID_doc_pertinenza = p.ID_doc_pertinenza) INNER JOIN doc_formato df ON df.ID_doc_formato = p.ID_doc_formato) INNER JOIN doc_tipo dt ON dt.ID_doc_tipo = p.ID_doc_tipo) where p.IDSocieta_mitt = #url.IDSocieta# or p.IDSocieta_dest = #url.IDSocieta# ORDER BY p.data desc, p.Protocollo desc SELECT distinct IDfile as IDfiles from elenco where IDfile > 0 UNION SELECT distinct IDfile2 as IDfiles from elenco where IDfile2 > 0

SELECT IDSocieta, Societa, eliminato FROM anagrafica SELECT IDutente, nome, cognome FROM utenti select * from files where IDfile IN (#IDfiles#,0) SELECT nome, cognome FROM addetti where IDutente = #elenco.IDutente_ins# SELECT Societa FROM aziende WHere IDSocieta = #elenco.IDSocieta_mitt# SELECT Societa FROM aziende WHere IDSocieta = #elenco.IDSocieta_dest# SELECT * from cerca where name = '#num_protocollo#.pdf' SELECT * from allegati where IDfile = #IDfile# SELECT * from allegati where IDfile = #IDfile2#

N°

data

Utente

Titolo

Mitt

Dest

Tipo

Formato

Pertinenza

#num_protocollo##Doc_pert_settore#

#dateformat(data, "dd/mm/yyyy")#

#datiutente.Cognome# #left(datiutente.nome,1)#.

#mitt.societa#

#dest.societa#

#doc_tipo#

#doc_Formato#

#doc_pertinenza#

Nessun record trovato !