select json_build_object('id', gs.id, 'cid', gs.cid, 'street', gs.street, 'lat', gs.lat, 'lng', gs.lng, 'zip',gc.zip, 'city',gc.city, 'country',gc.country, 'citizen',gc.citizen, 'county',gc.county, 'state',gc.state, 'district',gc.district) from geostreets as gs join geocities as gc on gs.cid = gc.id limit 1;
Created
November 25, 2018 22:53
-
-
Save p3t3r67x0/2185dd059d78d605e62b2449ef07470b to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment