python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - inner-join

PHP MySQL INNER JOIN query only returns one row when phpMyAdmin of same query returns four rows

I have two tables 'favorite' and 'image': 'favorite' - contains columns: username (varchar) unique identifier for user viewkey (varchar) unique identifier for image action (tinyint) 1 = image was fa...
test-img

Nyki-Anderson

php

mysql

sql

database

inner-join

Votes: 0

Answers: 1

Latest Answer

Answered I had previously used the variable $conditions which had a 'single' row paramater leftover. Reinitializing $conditions with $conditions = array (); cleared everything up. Thank you for the co...
test-img

Nyki-Anderson

Need to match ClockIn with Clock out, multiple clocks on same day SQL

I'm trying to get the clock in and clock out times to correspond to each other so that I can calculate hours worked/amount of breaks/time worked within working hours etc. I have a 'Clocking' table tha...
test-img

Jarryd vn

sql-server

join

inner-join

database-cursor

Votes: 0

Answers: 2

Latest Answer

You can do this in a single scan of the base table, and no joins, by using window functions: WITH NextValues AS ( SELECT *, NextClockOut = LEAD(CASE WHEN c.ActivityID = 2 THEN c.Clock_Time E...
test-img

Charlieface

MySQL UPDATE Two Tables with Differences From The First

I have two tables table1 and master. Master is the master database of contacts. Table1 contains recent contact information from a survey of respondents in a study. table1 contains current informatio...
test-img

Viktor

mysql

inner-join

update-inner-join

Votes: 0

Answers: 1

Latest Answer

You can use the following update. The where clause does not change the final result because we will overwrite rows which are already correct with the same value. UPDATE t1 INNER JOIN master ON t1.id =...
test-img

user18098820

How can I display which tower (Towerid, Location) was used by customer XX to make their first call?

I cannot get the result for the first call from a specific customer. I can get the result for all the calls from this specific customer. Table 1: Tower: TowerID, Location Table 2: Connect: Tower ID, C...
test-img

Bruna Maurer

mysql

inner-join

Votes: 0

Answers: 1

Latest Answer

You can use partition by in this case. I've not tested the below query but I hope it works. select temp.CustomerId, t.TowerId, t.Location from Tower t join Connect c on t.TowerId = c.TowerId ...
test-img

Harshal Pawar

Posts

Questions

Blogs

Jobs