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]
