I have also had this trouble before if there are say 5 results from the second table, the first table of results would be duplicated 5 times on a join, i would also like to know how to get around this.
> 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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]