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/my***********...ie.nctu.edu.tw