How to query/join data?

Use lkd_profile, lkd_company, lkd_job, and similar views, or look into their definition. Take note of snap_id significance: it’s used to filter out old and deleted experiences, education, and the like.

The views have comments defined on each of the columns that describe the data.

When running SELECT queries on views, prefer to select just the columns you need instead of all columns for faster responses.