MySQL Forums
Forum List  »  Other Migration

error ! Mysql performed the sql sentence , error result
Posted by: david liu
Date: July 12, 2004 02:54AM

the sentence as follows:

select * from
( select * from ...........) as A,
( select * from ...........) as B where "conditions".

I can't get the right result . and I can get the right result if I put A and B into two new-created tables, the use this sql sentence:
select * from table1, table2 where "conditons"

please tell me why !

thank you !

Options: ReplyQuote


Subject
Views
Written By
Posted
error ! Mysql performed the sql sentence , error result
3804
July 12, 2004 02:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.