Advanced Search

Return to Snippet

Revision: 24263
at February 24, 2010 15:04 by sveggiani
Initial Code 
UPDATE documents_logs, documents, documents_types
SET documents_logs.document_company_id = documents_types.company_id
WHERE documents.id = documents_logs.document_id AND documents_types.id = documents.documents_type_id
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Update table with data from a (pseudo) join

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL