Stack Overflow
Stack Overflow

Questions tagged [junction-table]

A junction table is a table that contains common fields from two or more tables and is the canonical way to implement Many-to-Many relations in SQL and Relational-type databases.

In database management systems following the relational model, a junction table is a table that contains common fields from two or more tables. It is on the many side of a one-to-many relationship with each of the other tables. Junction tables are known under many names such as bridge table and linking table.

221 questions
0
votes
1 answer

Getting data from junction table as a list of values for unique records

I have two tables connected with many-to-many relation by junction table: CREATE TABLE [dbo].[User]( [ID] [int] IDENTITY(1,1) NOT NULL, [name] [nvarchar](50) NOT NULL, [surname] [nvarchar](50) NOT NULL, ) CREATE TABLE…
KamCho
  • 131
  • 2
  • 10
0
votes
1 answer

how to insert into junction table when many to many with doctrine?

I am trying to insert into a junction table called post_post_category which is based on Post and PostCategory tables [many to many], i manage to execute the insert but the problem is that when i add a new post it creates a new category. Post…
DJava
  • 11
  • 5
0
votes
0 answers

Group a table with a junction table

I have a table EVENT and a table ATTENDEE. When grouped by its lookup values EVENT looks like this: |EVENT_ID|EVENT_TYPE|CITY|STATE|ZIP| Many events can have many attendees, so I then have an EVENT_ATTENDEE junction table: |EVENT_ID|ATTENDEE_ID| I…
Sean
  • 1
  • 3
0
votes
0 answers

yii2 related model not found during validation in junction table

I have a junction table Znw with 2 ids (a_id & wz_id), and a form with 2 select boxes according. I would like to check in the rules, if fieldn of the corresponding model a have the same value as field of the corresponding model wz. Rules: [['a_id',…
user2511599
  • 796
  • 1
  • 13
  • 38
0
votes
1 answer

Fill junction table by matching values in linked tables

I have a database with several articles and corresponding images (laying in different folders) There are 3 folders with Images of the products In one folder only technical images, in the other marketing images, in the third are high quality…
Mally
  • 19
  • 4
0
votes
3 answers

Spring : How to delete entry from junction table?

I have a junction table of user_id and favorite_property_id And now I want to delete the favorite property of the user , I tried the following method in repository but its not working , Does anybody have any idea that how can i delete he entry from…
SFAH
  • 624
  • 15
  • 35
0
votes
1 answer

Junction table in SQLite database

Well, I am trying to build an application which allows to exchange messages between instructors and students. And I need to build a ContentProvider class, but I have encountered a problem how to represent a many-to-many relationship between the…
nullbyte
  • 1,178
  • 8
  • 16
0
votes
2 answers

Junction Table in ASP .NET code first approach

I am creating a junction table between Identity User and a Game table. This table is called UserGame and has two foreign keys (UserID, GameID) and one additional field to store the score. public class UserGame { [Key] public string…
Gareth Quirke
  • 216
  • 1
  • 8
  • 25
0
votes
1 answer

When Querying Many-To-Many Relationship in SQL, Return Multiple Connections As an Array In Single Row?

Basically, I have 3 tables, titles, providers, and provider_titles. Let's say they look like this: | title_id | title_name | |------------|----------------| | 1 | San Andres | | 2 |Human Centipede | | 3 | …
alexbannon
  • 35
  • 4
0
votes
1 answer

Getting records from the database with many to many relationship in asp.net mvc

This is the structure of the database on which i am working.Click on this text. I want to select the EmailID of the users which belong to a particular CategoryID mentioned in MailStatusTable where the column MailStatus Contains False. This is the…
Ronak Kothari
  • 3
  • 5
0
votes
1 answer

Implementing a Junction Table

Current Build: Table (BND_Listing) as A contains store location information etc... Table (BND_ListingCategories) as B contains Categories to classify A I'm using query-strings to create a "Filter" function on my website that sorts A based on a…
UserSN
  • 953
  • 1
  • 11
  • 33
0
votes
2 answers

PHP Junction Table Relations (Many to Many), grasping concept

So I've tried searching and have yet to find out how to grasp this entirely. I'm reorganising my database because I was storing user id's as comma separated values in a column withing that row to control permissions. To me, this seems like a better…
user6468101
0
votes
1 answer

Insert data into junction table

I am trying to insert a set of data into a junction. I want to be able to set the default set of products to every new merchant that is created, then the merchant will have options to set their prices availability etc based on their needs. I have…
Boss Nass
  • 3,384
  • 9
  • 48
  • 90
0
votes
1 answer

Inserting into a join table if value does not already exist

I have 2 tables - user, region and a join/connecting table that is used to join both user and region. I need to insert into the join table all the region values that the user does not already have and i am unsure how to go about this. I have…
Perfect_Comment
  • 165
  • 1
  • 2
  • 15
0
votes
2 answers

Dsictint bi-directional relation

I have table that describes realtionships between other tables in database. Every user can have any file, and every file can have any user. If I get one files' relations and I don't have this file relation to user, but user has relation to that…
cssBlaster21895
  • 3,670
  • 20
  • 33
1 2 3
…
14 15