Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
Can I Do It ?
Thanks,
Rosen
Andrey Hristov wrote in message 071401c17759$f5873c80$0b01a8c0@ANDreY...
Mysql says that in the join there are some columns with namer datestamp so
you have to choose by
It sounds to me like what you're trying to do is APPEND data from three
similarly structured tables into one entity ordered by a column common
to all 3 tables called datestamp. If I'm mistaken, then please ignore
all of the following:
Approach #1 (mysql)
Create a temporary table with the
Thanks,
but I want wo JOIN data from three tables and then to order
all data by datestamp.
There must be more than one column called datestamp, this is why mysql is
telling you it's ambiguous.
So you need to tell it which table's datestamp column you wish to use.
for example your new