This is a good one - can't seem to find an example of how to use
Code: Select all
$query->union
Code: Select all
$query
I want to select similar data from different tables and use the join function that now exists in the query object.
SELECT field1,field2 FROM `#__mycomponent_table1` where field1 = 0
UNION
SELECT field1,field2 FROM `#__mycomponent_table2` where field1 = 0
etc...