I have been a MySQL user and supporter for over a decade (since 2001) and I am almost ashamed to admit that I haven=E2=80=99t the faintest idea on how to do joins and unions.
I have a specific query I would love to run=E2=80=A6
I have two tables, one with Unique data (=E2=80=9Cimages=E2=80=9D) and one with corresponding paths but many replicated records (=E2=80=9Cfiles=E2=80=9D).
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?
=E2=80=94 Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Aug 04
Wm Mussatto Re: Using Joins/Unions
Aug 04, 2015; 15:33
Wm Mussatto
Re: Using Joins/Unions
Aug 04
Ryan Coleman Re: Using Joins/Unions
Aug 04, 2015; 18:05
Ryan Coleman
Re: Using Joins/Unions
Aug 06
Wm Mussatto Re: Using Joins/Unions
Aug 06, 2015; 18:02
Wm Mussatto
Re: Using Joins/Unions
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!