Hello again experts.
I know enough to write a simple query from one table but despite the fact that I understand how these 3 tables are related I do not know how to query them to display the needed info the way I like.
The problem is the lookup table has IDs and values for each part of an address and when I query it with my statement each part of that lookup table comes up as a new row and not a column. ( please see attached pic ).
I really am trying as hard as I can to understand this.
Could an expert please direct me the right way?
My snapshots and scribblings should help explain what I am trying to do.
Thank you in advance.
FROM jml_locations, jml_location_fields_link, jml_location_fields
WHERE jml_locations.id=jml_location_fields_link.location_id AND jml_location_fields.id = jml_location_fields_link.location_fields_id