Hi Christian,
You can create a temporary table (see manual
http://www.mysql.com/doc/C/R/CREATE_TABLE.html) with the same structure as
prv or com and populate it with prv's and com's data by using
INSERT INTO SELECT ... syntax (see manual
http://www.mysql.com/doc/I/N/INSERT_SELECT.html)
Gurha
Hi Christian,
> i'm working on a project for managing used motorcycles. for security
reasons
> i setup two identical tables. both with the same attributes.
> ID,UNIID,Manufacurer... one of the tables is named "Com" and the other
> "Prv".
>
> till now i used to search either "Com" or "Prv". but i
Depending on which version of mysql you are using you could use
Union
http://www.mysql.com/doc/U/N/UNION.html
or you could use a Merge table
http://www.mysql.com/doc/M/E/MERGE.html
another option would be to place the results of both queries into a
temporary table
and query that.
-Origina
