MySQL Forums
Forum List  »  Performance

Re: distinct clause issue for 600000 records
Posted by: Ra Nala
Date: November 13, 2015 07:15AM

Sorry Sir @: Øystein Grøvlen, Not able to under stand your syntax : t1 LEFT JOIN (t2 JOIN t3 ON ...) ON ...

Could you please provide sample syntax for below tables, Don't mind please sir . .

I want to retrieve all data from prdsl .

select *
from prdsl psrl
left join prd prd on psrl.prdd=prd.prdd
left join be_en beship on beship.id=psrl.ship_bed
left join be_en beinv on beinv.id=psrl.invoice_bed

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: distinct clause issue for 600000 records
867
November 13, 2015 07:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.