fedkris
asked on
sql, merge two tables (nothing in common)
hello,
we have two different tables, with fields: date, name event, ....
one table = events
one table = seminars
how can we, combine those, in a query to obtain a list, ordered by date
exemple:
table event, contains:
idevent 1 date 1/01/2013 name: test event
idevent 2 date 2/02/2013 name: test event 2
table seminar, contains:
idseminar 1 date 15/01/2013 name= seminar 1
the result in my webpage should be:
idevent 1 date 1/01/2013 name: test event
idseminar 1 date 15/01/2013 name= seminar 1
idevent 2 date 2/02/2013 name: test event 2
how can we do this, someone any ideas? thx in advance
kristof
we have two different tables, with fields: date, name event, ....
one table = events
one table = seminars
how can we, combine those, in a query to obtain a list, ordered by date
exemple:
table event, contains:
idevent 1 date 1/01/2013 name: test event
idevent 2 date 2/02/2013 name: test event 2
table seminar, contains:
idseminar 1 date 15/01/2013 name= seminar 1
the result in my webpage should be:
idevent 1 date 1/01/2013 name: test event
idseminar 1 date 15/01/2013 name= seminar 1
idevent 2 date 2/02/2013 name: test event 2
how can we do this, someone any ideas? thx in advance
kristof
Classic homework assignment. ;)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.