select query in a database

Asked

Viewed 27 times

0

good is the following I am to stir here with some data, I have a table with data of the censuses.

Tables

First table where you have the data .

Fields residencia_nut3, work values 112, 180 values 149,146

nuttable 3 fields id,Description values 112 port values 149 coimba values 180 Lisboa values 146 Santarem

table nut2 fields id,Description values 11 north 14 center 18 south

now I can do data stream with nut3 but with Nut 2 I don’t know how to do . associate Nut 3 to Nut 2.

  • 1

    You could explain your question better, better defining the tables and their fields and the table/field relation. Could you put in their creation code? It makes it easier to help you :)

  • Now, look at the light.

  • I thought to leave the Nut 3 and compare with the first 2 numbers...so I already find the nut2 of the corresponding nut3

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.