qProject >>
SELECT
p.id,
p.name
FROM
project p
WHERE
p.id = #project_id#
qAsset >>
SELECT
a.id,
a.name,
a.filename,
a.project_id
FROM
asset a
WHERE
a.id = #asset_id#
Validation >>
if
(NOT qProject.RecordCount) OR
(NOT qAsset.RecordCount) OR
(qProject.id NEQ qAsset.project_id)
then
// Throw error that data was not valid.