Połączenie dwóch zapytań w jedno., Połączenie dwóch zapytan w jedno. Opcje

[Ardo]

jak połączyć te dwa zapytania w jedno:

[SQL] pobierz, plaintext 
$sql =  "SELECT * FROM   object  
	INNER JOIN promocja  
	ON object.obId  = promocja.oglId 
	WHERE    promocja.obDateEnd  BETWEEN '".$_SESSION['data_po2']."' AND '".$_SESSION['data_ko2']."'  
	GROUP BY promocja.oglId";
[SQL] pobierz, plaintext 

z tym zapytaniem:

[SQL] pobierz, plaintext 
$sql = "SELECT a.*, b.*, c.*  
FROM object AS a, type AS b, state AS c  
WHERE a.obTypeId = b.typeId AND a.obStateId = c.stateId   AND a.obConfirm = '1' AND a.obDateEnd > NOW()";
[SQL] pobierz, plaintext 

[mmmmmmm]

[SQL] pobierz, plaintext 
SELECT obId, obName, obStateId, obPriceOn, obConfirm, obDateEnd, obTypeId, obCity, obRoom, obTeren, obNearby, NULL typeId, NULL typeName, NULL typeNameen, NULL typeNamedo, NULL stateId, NULL stateName 
FROM object
INNER JOIN promocja ON object.obId = promocja.oglId
WHERE promocja.obDateEnd
BETWEEN '2012-08-01'
AND '2012-12-30'
 
UNION ALL
 
SELECT a.obId, a.obName, a.obStateId, a.obPriceOn, a.obConfirm, a.obDateEnd,  a.obTypeId, a.obCity, a.obRoom, a.obTeren, a.obNearby,  b.typeId, typeName, typeNameen, typeNamedo, c.stateId, c.stateName 
FROM object AS a, type AS b, state AS c  
WHERE a.obTypeId = b.typeId AND a.obStateId = c.stateId   AND a.obConfirm = '1' AND a.obDateEnd > NOW()
[SQL] pobierz, plaintext