How does one perform a sub query with different post types

How does one perform a sub query with different post types

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)