mysql - Select from one table and order by column of another table -

-

I am very new to MySQL and I could not find any solution for this problem. I appreciate all kind of help.

I have Table A and Table B, which are interconnected. I want to order a result from Table A. and order results by 'Date' column in Table B. This table is linked by 'user_id' My table is given below: 

  Table A: ... name user_id (link to table b) Table B: user_id date

Is it possible to do that? Thanks for any help!

You want to include an interior. Something like this: 

  Außer_ID, A name, be it a sign in Join B from BUUSER_ID = AUser_ID WHERE (whatever is your filtering) ORDER BY B.date

You should do some research on joining as it is an important and important thing for the development of the database (and knowing a good deal about it helps in building a good architecture).

The essence of this is that for every user_id in A, I want to find the matching user_id in B (due to the line INNER JOIN B at B.user_id = A.user_id). An internal insertion brings only in fairs, so if A has an ID of 2, but there are no 2 IDs in B, then it will not record (similar to record in B without record in A)

Now, the noticeable thing is that if I have a record with a user ID in 5, but there are two records in B with the User ID in 5, then in an internal investment There will be two records, each of the B. data in the data

Now, as your comment has been asked for this question, you want to get a higher rating, you want maximum function. 

  Ausser_ID, b. Deat, Max (Britting) A Inner Join on On B User AID = AUser_ID WHERE (whatever your filtering is) by BDT by Group by Euser_ID, there are two parts, total work maximum () and statement by group. They work together so that for each unique Ears_ID, the database will bring back the highest recordings. You can also use functions like Min () which is the opposite, selection of berting, or calculation (which will calculate the record events, or yoga) that will add the records of that column. 
 
 With database queries as always, play with them, make sure you get the right data back and you understand why when I create questions, I usually get from the table Selection begins with *, I understand what I should be involved, along with my records look fine, then restricting the columns and start filtering things Your benefit may vary on method, but To verify the data is always a good idea.

Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more