how to get the columns from multiple tables into a single qu
                            
                         
                        
                     
                 
                
                    I m doibg a online shopping website and in dat I want a page dat fetches the order history of a customer but problem is the order table do not contain customer id and want the customer id should be selected from customers table should I use nested query...plz any suggestion?