Web lists-archives.com

Re: Using Joins/Unions




No but there should be. If there's not my task is useless. 

Secondly yes. Unique name on it too. 

--
Ryan Coleman
Publisher, d3photography.com
ryan.coleman@xxxxxxxx
m. 651.373.5015
o. 612.568.2749

> On Aug 4, 2015, at 17:33, Wm Mussatto <mussatto@xxxxxxx> wrote:
> 
>> 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?
>> 
>> —
>> Ryan
> 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
> Systems Engineer
> http://www.csz.com
> 909-920-9154
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql