I have two tables, let's call them `[Table1]` and `[Table2]`.

I need to get the TOP 1 record from both tables 

```
where [ChargeDate] > dateadd(hh, -1, getdate())

```

The problem is that I am using a CROSS JOIN when there is no record in `[Table1]`.

The result being that no records were returned by the query. Any suggestions on what query I can write which will return records even if there is no data in one of the two tables?