> So, can somebody please correct the following query (and explain the > syntax) so that it will work please? (I haven't tried putting an outer > join in it because I don't understand the syntax.) > > Select > actr.name, > acto.name, > dvd.title > from > actresses actr, > actors acto, > dvd > where > actr.actr_id = dvd.actr_id > and > acto.acto_id = dvd.acto_id > order by dvd.title; > > (I used to put (+) at the end of the outer join line, but don't think > this will work in MYSQL - at least I don't see it in the manual.) > > Thanks in advance for your kind help and sorry for the wordy question!
i have not really used outer join, i'm still trying to fine tune my sql aswell but to get null values i use left join, to return not null values i use inner join, i select from the first table first though, is it better to select it at the end ? so soemthing like select * from dvd left join actresses actr on actr.actr_id=dvd.actr_id left join actors acto on acto.acto_id=dvd.acto_id or by dvd.title -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]