Questions tagged [multi-table]
138 questions
0
votes
1 answer
Multi-Table join in hibernate
I have a case in which I have to join 3 tables. The situation is like as below:
Asset table.
Transaction table.
Employee table.
Now,
a) Asset can have multiple Transactions there is a relationship of OneToMany.
b) One Transaction can belong to…
Rider
- 463
- 1
- 9
- 19
0
votes
2 answers
Laravel eloquent ,has many in multi table
i have three tables inventory,products,product_category
in table:inventory
id product_name quantity
1 2 24
2 2 54653
3 1 34
here product_name is foreign key..this table has many relation with…
Borna
- 538
- 4
- 19
0
votes
1 answer
Renaming a Key on a multi-table MySQL SELECT
I'm trying to get the content of 3 different tables.
table A = Is containing our users list, table B = Is returning contracts related to users,table C = Is returning formula details related to the contracts.
In order to make it the right way, I'm…
ElBigZob
- 5
- 3
0
votes
2 answers
SQL: Update with value from other table depending on timestamp
I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the…
sugomat
- 1
- 1
0
votes
1 answer
MySQL query only returns results if both tables have rows
Problem:
In my mysql database, I have two tables lists and shares. The lists table has all of the to do lists that users have created:
The shares table stores all lists that have been shared from one user to another:
What I want to do is get all…
Vaughn Dabney
- 94
- 8
0
votes
1 answer
multi-table insert using sequence-generated id fails due to foreign key violation
I want to bulk insert explicit data into two different tables linked by a foreign key using a same sequence-generated value in both tables.
I'm trying to use a INSERT ALL instruction together with a WITH clause made of successive UNION ALL…
Thomas Naskali
- 551
- 5
- 19
0
votes
1 answer
how build objects with alamofire and SwiftyJSON
I'm trying to create an app that returns Multi-up table with many data but I think I would need a completion handler in here.
// object data :
import Foundation
class RepoSwiftyJSON:NSObject {
let _userId:String!
let _title:String!
…
phantom
- 112
- 8
0
votes
1 answer
PHP PDO UPDATE MySQL Multiple Tables
I am learning PHP PDO with MySQL and wanted to know how to update multiple tables with one Update query linked from a single row in Table 1.
Example if I wanted to update a value in table 2 and/or 3 with one query knowing only table 1 record PK id.…
newpie
- 77
- 8
0
votes
2 answers
How to return multi-table join value from BLL
This question is regarding the ASP.NET webservice that i am creating using the DAL-BLL architecture for my final school project.
I have a stored procedure, which is a select query with an inner join for 2 tables. Hence the stored procedure returns…
Batul
- 85
- 1
- 1
- 7
0
votes
2 answers
Comparing SQL Table
Thanks for looking at this. Someone smarter than me will have this answer but I have reached my limits.
I have three separate tables and am trying to compare them against each other for the purpose of testing some reports. Each of these tables are…
Anvil
- 1
0
votes
3 answers
How to join one to many distinct in three table?
I have three table I want to join
Table: Student
ID Fname Lname
--------------------------------
1 Jhon gates
Table: Registration Info
ID RegisterDate StudentID_FK ClassID_FK
----------------------------------------------------
1 …
Mr Alemi
- 830
- 1
- 10
- 21
0
votes
1 answer
mapping entity from multiple table with NHibernate
I hope you can help somewhat novice to NHibernate with the following question.
Suppose we have two table: Page and WorkPage. Page table contains unversioned data and WorkPage contains versioned Data of the same Page, i.e. there is a relation…
Eugene Strizhok
- 1,145
- 2
- 12
- 19
0
votes
0 answers
Multi Table wiht like statement: Works in Toad - not in FME SQL Query
So I have a multi table joiner that I have been succesful with inside of Toad but I cannot get to excute inside of a SQLite transformer in FME.
I am essentially wanting to join the Region table to the Entry table if the column Entry.Category…
Garrettasdf
- 1
- 1
0
votes
1 answer
Inserting data from a form to multiple tables in a mysql database using php
The data inserts into the first table, but the code for getting the ID numbers doesn't seem to work, and the data is not inserted into the next two tables.
The code runs and the Thank you message appears thanking the person for submitting their…
across
- 1
- 1
- 2
0
votes
1 answer
Merging 3 MySQL Tables Into Consolidated Table Getting Too Many Results
I have 3 tables: members, products, product_costs
I need to consolidate the info from these tables into one single table. When I do this, I'm getting far too many results and I'm not sure why.
For every product, there should be a cost, but there…
Mike Smith
- 3
- 1