Joining two queries

[ofsouto]

Is it possible to join these two queries in only one query?
If the first query returns a null value I need get the value from the 2nd query.

SELECT MIN(A.CODE) FROM TABLE_A A, TABLE_B B
WHERE A.VALUE >= B.VALUE

SELECT MAX(A.CODE) FROM TABLE_A A, TABLE_B B
WHERE A.VALUE < B.VALUE

Thanks in advance.

 

[NoCoolHandle]

SELECT MIN(A.CODE) FROM TABLE_A A, TABLE_B B
WHERE A.VALUE >= B.VALUE
[red]Union [all][/red]
SELECT MAX(A.CODE) FROM TABLE_A A, TABLE_B B
WHERE A.VALUE < B.VALUE

 

[billchris]

SELECT
  ISNULL
  (
    (
      SELECT 
        MIN(A.CODE) 
      FROM 
        TABLE_A A, TABLE_B B
      WHERE 
        A.VALUE >= B.VALUE  
    ),
    (
      SELECT 
        MAX(A.CODE) 
      FROM 
        TABLE_A A, TABLE_B B
      WHERE 
        A.VALUE < B.VALUE
    (
  )

“I apologize for this long letter. I didn't have the time to make it any shorter” --Blaise Pascal