Stack Overflow
Stack Overflow

Questions tagged [multi-table]

138 questions
0
votes
0 answers

How do I cover up half of a multiplication table?

So we need to write a program where you input a number and the program generates a multiplication table that looks like a ramp going to the right, or a right triangle. I have been able to generate a square table, but now I need to use an if…
kevinemart
  • 1
  • 1
0
votes
0 answers

Inherited model with FK to base model overwrites base reference

I have a situation where I have 2 models, with the second model (B) being a subclass of the first (A), and also having a (different) 1-to-1 reference to another instance of same parent model (A). The objective is to have some special cases of A…
Maps
  • 135
  • 10
0
votes
1 answer

MySQL sum() from more than 1 table

SELECT fee + sum(((hourEnd-hourStart)*4) as sumAct3 from reserve join activity on reserve.idactivity=activity.idactivity join customer on customer.idcustomer=reserve.idcustomer where activity.typeAct=1 and…
RandomName
  • 5
  • 1
0
votes
2 answers

Each When condition is tested for each row returned by the subquery?

So I set the autotrace on ramin.tb001 had 10 rows. In 1 version I use equality and in second less than I want to know is the When condions reads 10 rows from ramin.tb001 and check condition or how?
user9135988
0
votes
1 answer

mysQL group_concat from multi table and count

I tried to convert single table to multi table extraction single table which is working perfect but multi table extraction is giving error. please any one can help db-fiddle single table which is working perfect …
programmergeeky
  • 15
  • 5
0
votes
1 answer

searching data with multi table from database

I have a database that consists of many tables that contain data on a resident. the table is separated by year of birth and month. for example those born in 01 of 1980, then the data is stored with the name table table_8001, and so on. so I will…
rzl21
  • 43
  • 1
  • 7
0
votes
1 answer

Select in multiples tables PSQL without join

(Please correct my if i do some mistakes) I have 2 tables: ACTIVITIES : ID / NAME / CONTENT / DATE /ETC.. ARTICLES : ID / NAME /CONTENT /DATE /ETC.. I have created one script to delete image when it is not in the db , the problem is : I don't…
Benjamin Barbé
  • 281
  • 2
  • 4
  • 16
0
votes
1 answer

How can I work with multiple tables on database in ASP.NET Core 2

I have a database named "a" with the tables "aha", "aho" and "ahi". How can I show them in one view on MVC? I use ASP.NET Core 2.
aha.name
aha.address
aha.phonenumber
aho.id
…
Bình An Lê
  • 5
  • 1
  • 4
0
votes
2 answers

how to combine two 'count' value from different tables (2 column, NOT union)

I want to get the count of addmited records by user in 2 table. for example, I have a list of users(table STF) and want to know how many product did a user create (in table PV1) and how many product did he sell (in table dpq), I want to show these…
N. N
  • 19
  • 6
0
votes
1 answer

Oracle Multi Table Insert with one parent / multiple child relationships

I'm trying to develop an efficient XML parse routine that uses a multi table insert from a data source with parent/child relationships. I want 1 parent and multiple child records inserted simultaneously. Unfortunately I'm getting the same number of…
Lee Greco
  • 743
  • 2
  • 11
  • 23
0
votes
1 answer

How to make Multi Table Sub Query less wordy Access

I am trying to make a query to find all details of students interviewed more than once I have gotten the results successfully using: SELECT S.StudNo, S.StudLName, S.StudFName, S.StudMobile, S.City, S.DateEnrolled, S.ProgNo, S.AmountDue,…
Puff
  • 1
  • 3
0
votes
5 answers

Combine 3 queries using inner join

I have 3 tables that I am trying to pull information from. Sample data shown below TABLE Trip idTrip Title Date 1 Ben Lomond 08-08-2016 TABLE Person_has_trip Trip_idTrip Person_idPerson 1 1 1 2 TABLE…
David Jack
  • 87
  • 6
0
votes
3 answers

Empty id in MySQL, cannot show null answers

I got this, and I want to get their "company" names for each one. SELECT `client`.`name`,`client`.`lastname` FROM `check`,`reserv`,`client` WHERE `check`.`idReserv`=`reserv`.`id` AND `reserv`.`idPerson`=`client`.`id` ORDER BY `check`.`id` , and I…
Feber Castellon
  • 509
  • 1
  • 7
  • 21
0
votes
2 answers

Django - Getting records from first table based on Second table' field value

I am developing a Django App, in which I have used PostgreSQL as a Database. The models in the Application are as follow. class topics(models.Model): topicid = models.IntegerField() topicname = models.CharField(max_length=512) …
Hemal Pandya
  • 27
  • 2
  • 8
0
votes
2 answers

MySql get data from multiple tables results from a select

I have a table "move" like this ---------------------------------- | id | ... | ... | tab | idTab | ---------------------------------- | 1 | ... | ... | bike | 14 | | 2 | ... | ... | car | 57 | | 3 | ... | ... | car | 23 | | 4 |…
Francesco G.
  • 679
  • 3
  • 13
  • 32
1 2 3
…
9 10