SQL query question
Not sure if this matters, but I have an ODBC connection with my Wordpress site and I need to get some information into a field in Filemaker with a calculation...just not sure on the calculation.
2 tables (wp_posts, wp_postmeta)
I have them connected correctly wp_post:id -> wp_postmeta:post_id
Within the postmeta table there are three other fields (meta_id, meta_key, meta_value)
I am trying to get all of the values within the field "meta_key" of "_my_meta_value_key".
Here is the Query my developer gave me..not sure if it helps, but incase I missed something.