Because both tables have a column ticid, we need to qualify the name in the select part as well. Within one database the fully qualified name has to be unique. A fully qualified column name has the format schema_name.table_lumn_name Because both tables contain a column ticid, we have to qualify the column names, here it is sufficient to just add the table-name in front. The on () construction tells it how to do it: we want the values of the column ticid in both tables to be identical. The second point tells the database to join ticvals_master to ticlink_master.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |