Joined tables are always merged into a single table. Joins must be defined between physical tables upfront before analysis and can’t be changed without impacting all sheets using that data source. Joins are a more static way to combine data. So, we can join the two tables using ProductID. ![]() In the Products table, ProductID is the primary key. If you have studied SQL, then you remember that inside the Orders table, OrderID is a primary key, and ProductID is a foreign key. That means we have connected or joined a table using ProductID. ![]() Now, when the user places an order, then inside the order table, ProductID is stored.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |