2 table put it in 1 query

  • Thread starter Thread starter a
  • Start date Start date
A

a

Thank you
table 1
ID comapany empname
1 ms a
2 hp b
table2
ID comapany empname
1 canon a
2 Fox b
The Question: compin 2 table in one query like the following:
ID comapany empname
1 ms a
2 hp b
1 canon a
2 Fox b
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Union query:

SELECT ID, Company, EmpName
FROM table1

UNION ALL

SELECT ID, Company, EmpName
FROM table2

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0JLoechKqOuFEgEQJgxwCg+wu0wiSDHuFmMgv6osGRfGUCkpwAnjEJ
WN7gQZ6ZaNGhbwZsfvKZ1ayW
=qDLf
-----END PGP SIGNATURE-----
 
Back
Top