Query returning related assets
- by GMo
I have 2 tables, one is an assets table which holds digital assets (e.g. article, images etc), the 2nd table is an asset_links table which maps 1-1 relationships between assets contained within the assets table.
Here are the table definitions:
Asset
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null |…