Lorenzo Rossi frollo

## jdatabase.md

      
        
          
            
              
              1 file
            
          
          
            
              
              3 forks
            
          
          
            
              
              7 comments
            
          
          
            
              
              13 stars
            
          
        
        
          
              
          
          
            
                gunjanpatel
                / jdatabase.md
            
            
              Last active
              November 14, 2022 12:26
            
              
                Write subquery in Joomla 3 using JDatabase method.
              
          
        
      
        
  
      
    Here is an example of how to write subquery in Joomla! 3 using JDatabase method.

<?php
// Initialize variables.
$db       = JFactory::getDbo();
$subQuery = $db->getQuery(true);
$query    = $db->getQuery(true);

// Create the base subQuery select statement.