{sql : select * from cat_archive
where cat_archive.ern = @enter ERN@
}

Dyfed Archaeological Trust,

Corner House,

6 Carmarthen Street,

Llandeilo,

Carmarthenshire,

SA19 6AE

Tel (01558) 823131

Email info@dyfedarchaeology.org.uk


{subtable :
SELECT cat_archive.ern,
ifnull(cat_archive.project_title,' ') as P1,
ifnull(cat_archive.related_prns,' ') as rel_1,
ifnull(cat_archive.related_nprns,' ') as rel_2,
ifnull(cat_archive.related_sms,' ') as rel_3,
ifnull(cat_archive.related_lbs,' ') as rel_4,
ifnull(cat_archive.other_ref_nos,' ') as rel_5,
cat_archive.ngr,
cat_archive.site_name_and_address,
ifnull(cat_archive.site_types,' ') as type_1,
ifnull(cat_archive.project_types,' ') as type_2,
cat_archive.client,
cat_archive.project_manager,
cat_archive.project_date,
cat_archive.categories_present,
cat_archive.location_digital as location1,
cat_archive.accession_no as accession1,
cat_archive.copyright_digital as copyright1,
cat_archive.access_restrictions as access1,
cat_archive.paper_location as location2,
cat_archive.accession_no_paper as accession2,
cat_archive.copyright_paper_archive as copyright2,
cat_archive.paper_access_restriction as access2,
cat_archive.location_finds as location3,
cat_archive.accession_no_finds as accession3,
cat_archive.copyright_finds_archive as copyright3,
cat_archive.access_restrictions_finds as access3
from cat_archive
where cat_archive.ern=[ern]
group by cat_archive.ern;

title:[b]ERN  -  [/b] ,ern,  [br][b]Project Title  -  [/b] ,P1, [br][b]Related PRNs -  [/b] ,rel_1, [br] [b]Related NPRNs -  [/b] ,rel_2, [br][b]Related SM Nos -  [/b] ,rel_3,  [br][b]Related LB Nos -  [/b] ,rel_4, [br][b]Other related ref nos -  [/b] ,rel_5, [br][b]NGR -  [/b] ,ngr, [br][b]Site Name and Address -  [/b] ,site_name_and_address, [br][b]Site type/s -  [/b] ,type_1, [br][b]Projecttype/s -  [/b] ,type_2, [br][b]Client -  [/b] ,client, [br][b]Project Manager -  [/b] ,project_manager, [br][b]Project dates -  [/b] ,project_date, [br][b]Categories present from archive index -  [/b] ,categories_present, [br][b]Location of digital archive -  [/b] ,location1, [br][b]Accession No of digital archive -  [/b] ,accession1, [br][b]Copyright of digital archive -  [/b] ,copyright1, [br][b]Restrictions on access to digital archive -  [/b] ,access1, [br][b]Location of paper archive -  [/b] ,location2, [br][b]Accession No of paper archive -  [/b] ,accession2, [br][b]Copyright of paper archive -  [/b] ,copyright2, [br][b]Restrictions on access to paper archive -  [/b] ,access2, [br][b]Location of finds archive -  [/b] ,location3, [br][b]Accession No of finds  archive -  [/b] ,accession3, [br][b]Copyright of finds archive -  [/b] ,copyright3, [br][b]Restrictions on access to finds archive -  [/b] ,access3, }