MySQL | Forum profile

sorry, i have no idea what you just said

Quote: Originally Posted by r937 they're nice diagrams but they don't make sense without seeing the sample data (plus, the author loses credibility by allowing SPAM in the comments) here's another visualization: http://www.sitepoint.com/forums/show...2&postcount=18 this one has great sample data , but without the bubble diagrams But much more explanation and good example can be found at Simply Sql 's Join chapters

Ok i will try to explain better : This is the query : Code: SELECT something , anything , just_not_the_dreaded_evil_select_star FROM galobj AS g INNER JOIN fonti AS fnt ON fnt.fnt_id = g.fnt_id INNER JOIN ( SELECT fnt_id , MAX(frmt_id) AS latest FROM formati WHERE frmt_subtype = 'jpeg' AND frmt_extra1 >= 550 AND frmt_extra1 <= 650 AND frmt_extra2 >= 550 AND frmt_extra2 <= 650 GROUP BY fnt_id ) AS m ON...

An error displayed : #1271 - Illegal mix of collations for operation ' IN ' SELECT * FROM cd WHERE week IN ('Te','Tev','Yed') Please advise.

MySQL Code: SELECT count ( * ) FROM tbl_name WHERE col1 NOT LIKE 'val1%' AND    col1 NOT LIKE 'val2%' ;

Quote: Originally Posted by leelong is that mean all of the table 'id' field must have same number of rows? sadly i hv different number of id field each table, 'table1' 2 rows of id datas, 'table2' 1 row, 'table3' 100 rows ........etc No, it doesn't matter if the number of rows in one table is different from the number in another. The join syntax joins the tables if there are relative rows/records,...

Hi Chaps, I have a Query that pulls data from 3 different job tables: Code: tbl_jobs - jobid (auto) primary key - jobinvsent (y,n) tbl_jobxml - jobid (auto) primary key - jobinvsent (y,n) tbl_jobtrans - jobid (auto) primary key - jobinvsent (y,n) I'm able to present the data in an HTML table, but what I need is the ability to update the values of jobinvsent to 'y' of all the jobid's presented. I'm guessing I'll...

Dear r937 Thanks a lot for your help on this. It works like a charm. Instead of UNION ALL I've used UNION because I don't want to retrieve duplicate values on this case, mutatis mutantis, here is the final working code thanks to you: Code: SELECT p.id_prod, p.id_cat, p.nome_prod FROM produto p INNER JOIN categoria c ON c.id_cat = p.id_cat INNER JOIN categoria c2 ON c.parent_id_cat = c2.id_cat WHERE c2.parent_id_cat = 1 UNION SELECT...

I'm trying to modify an existing query to count mails sent today by member_id1 to member_id2 (unique) that are NOT replies to an existing message from member_id2 (reply time frame of 7 days). Replies are just based on the "subject" field, if the Subject is the same it is considered a reply. The existing query is rather simple: SELECT * FROM messages WHERE member_id1=8 AND senddate>=" . mktime(0, 0, 0) ....

lol… are sure