Re: Using Joins/Unions
- Date: Tue, 4 Aug 2015 15:33:48 -0700
- From: "Wm Mussatto" <mussatto@xxxxxxx>
- Subject: Re: Using Joins/Unions
On Tue, August 4, 2015 11:19, Ryan Coleman wrote:
> I have been a MySQL user and supporter for over a decade (since 2001) and
> I am almost ashamed to admit that I haven’t the faintest idea on how to do
> joins and unions.
> I have a specific query I would love to run…
> I have two tables, one with Unique data (“images”) and one with
> corresponding paths but many replicated records (“files”).
> I want to run a query that takes the results from /images/ and also
> searches /images.file/ as a LIKE statement from /files.path/, sort by
> /files.filesize/ in descending order returning just the first record
> (largest file size). There may be up to 750 records from /images/ and
> thusly could be 3000+ from /files/.
> How on earth do I do this?
First question, will there always be at least one record in the files
table for every record in the images table? That controls the kind of
join you will use. I don't think that a union is a player. Also, is there
a unique record ID in each of the table?
William R. Mussatto
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql