Linked Questions

45 votes

8 answers

135k views

Following are my query and I want the result as given below. How can I do this in mysql ? SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons FULL JOIN Orders ON Persons.P_Id=...

7 votes

3 answers

43k views

I have two tables, one of them is empty but the other isn't. hugot_votes_stats : http://prntscr.com/72ft7d hugot_comment_stats: Empty I understand that I can't use Inner JOIN because it will only ...

3 votes

2 answers

2k views

Following are my two tables; I want the results as illustrated in the third table. How can I do this in MySQL (assuming FULL JOIN)? table_sales product_id quantity date c001 20 ...

0 votes

1 answer

5k views

I have 2 views with columns, view1 = (ID, Number) view2 = (ID, Number, Name) How to create select display such that Display = (ID, Number, Name) and Display is the FULL OUTER JOIN view1 and view2.

1 vote

1 answer

2k views

Hello I am trying to execute a query in mysql but i am getting following error query :- SELECT * FROM user_registration FULL OUTER JOIN user_details ON user_registration.email = user_details.gmail ...

0 votes

2 answers

2k views

I've got to tables with different columns and different numbers of rows +----+----------+--------+------+-------+---------+-------+--------+--------+------+ | ID | Name | SpT | Teff | RAdeg | ...

0 votes

1 answer

4k views

I have a scenario with MySQL joins Look at the 2 tables given below Table1: id A B 1 10 25 2 13 24 3 15 20 Table 2: id C D 2 12 21 3 10 18 4 13 23 My problem is to ...

-1 votes

2 answers

2k views

I need to apply full join in mysql. My query:- SELECT * FROM users FULL JOIN userdetails on users.user_id=userdetails.user_id How can i alter my query to achieve full join Please help

1 vote

2 answers

1k views

Here i am trying to run one query in MySQL editor and getting one problem Here is my query select * FROM my_db.persons FULL JOIN my_db.employee ON persons.PersonID=employee.PersonID; Any help ...

0 votes

1 answer

1k views

I always got an error from mysql my syntax is: SELECT n.id, n.name, s.Surname, s.Gender FROM name FULL JOIN Surname ON n.id = s.id; (i was doing full join) help me

0 votes

1 answer

684 views

I have a error in my SQL: "SELECT * FROM tireOverview FULL OUTER JOIN tirePrice ON tireOverview.ID=tirePrice.IDtire" Where i get this error: Fatal error: Uncaught PDOException: SQLSTATE[...

2 votes

1 answer

478 views

I have two mysql tables which structurally are identical. What I need to do is to compare the content of both tables. There are many answers out there how to show the rows that appear in one table ...

-2 votes

1 answer

312 views

How to do full joins in mysql? and what are the types of joins will support in mysql. Im a begginer in mysql please help me solve this issue. Thank you!

0 votes

1 answer

401 views

I have the following tables and I need to join them: Table A +----+----------+--------+ | ID | Period | Value | +----+----------+--------+ | 1 |2009年02月01日| 20.3 | | 2 |2009年03月01日| 22.5 | | ...

3 votes

2 answers

191 views

I have two tables: VOTES ID | YEARMONTH | VOTES ======================== 1 | 201101 | 23 1 | 201102 | 12 1 | 201103 | 12 2 | 201101 | 15 3 | 201102 | 1 4 | 201102 | ...