Plz help me make an SQL Statement for this

[DeathFox]

---

I got two tables, Physical and Dental

Physical has Description, Date, Pet_Number and Dental has the same

How Do I make it so it will look like this

Physical Description | Physical Date
Dental Description | Dental Date

And ma.arange sile by their date. I tried to cross join pero ang mugawas kay Physical Description | Physical Date | Dental Description | Dental Date


Plz help me make an SQL Statement for this

[dlanyer77]

union - operator returns results from both queries after eliminating duplications
union all - operator returns results from both queries, including all duplications
intersect - returns rows that are common to both queries
minus - returns rows in the first query that are not present in the second query

select description, date, per_number
from physical
UNION
select description, date, per_number
from dental

or

select a.description, a.date, a.per_number
from (select description, date, per_number
from physical
UNION ALL
select description, date, per_number
from dental) a
order by a.date

[DeathFox]

Thanks

[dlanyer77]

your welcome bro.