Check on the availability of data in the database and receive a result?
Good afternoon, I have a table A, it looks like this:
And there is a table with data B
Question can I use sql like to protonirovanie table B. addressid on the coincidence of values of c A. id, and if the table has any values with the same id, then output to A table with an extra field of type hasThisIdInBTable: true/false
if in Sql there is such possibility, how it can be implemented?