Hi Kim, no offense, but are you actually using the JOIN syntax correctly ?
Could you post your query please ? My guess is you are doing a JOIN without any set conditions. hat would give you the result as described (which is normal). You would use the WHERE clause or for a LEFT JOIN ...the ON clause to filter to correct data which you are requesting. Please have a look once more at the JOIN syntax: http://www.mysql.com/doc/en/JOIN.html Some examples: mysql> SELECT * FROM table1,table2 WHERE table1.id=table2.id; mysql> SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id; mysql> SELECT * FROM table1 LEFT JOIN table2 USING (id); Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 09:25、Kim Kohen さんは書きました: > G'day all, > > I'm pretty new to MySQL and very new to v4. > > This is probably going to sound strange, but is it possible to create a > union using the logic of a join? I have 4 tables and I need to join data > from them, but I'd like to display them like a Union. If I do a straight > join, I get lots of multiple entries thus: > > Page Ad_num status stories > 1 4312-T1308 Ad Complete 1-marchingband-A33 Placed > 1 4312-T1308 Ad Complete 1-jobs-T33 Placed > 1 4312-T1308 Ad Complete 1-illegalbuild-A32 Placed > 1 4312-T1308 Ad Complete 1-haldonstfesty-T33 Placed > 1 4312-T1308 Ad Complete 1-jobs-T33 Corrected > 1 4312-T1308 Ad Complete 1-car crash-T33 Placed > > Where ad_num "1 4312-T1308 Ad Complete" is replicated to accommodate > all the Joined data from the 'stories' table > > What I'd like to see is something like this: > > 1 4312-T1308 Ad Complete > 1 1-marchingband-A33 Placed > 1 1-jobs-T33 Placed > 1 1-jobs-T33 Corrected > 1 1-illegalbuild-A32 Placed > 1 1-haldonstfesty-T33 Placed > 1 1-car crash-T33 Placed > > Is this sort of thing possible? > > cheers > > kim -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
