471,067 Members | 1,544 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,067 software developers and data experts.

Table field merge

Hi all

Hoping someone can point me in the correct direction.

Does anyone know the SQL syntax to merge various table fields?

Thanks
Dec 4 '06 #1
2 2517
sashi
1,754 Expert 1GB
Hi all

Hoping someone can point me in the correct direction.

Does anyone know the SQL syntax to merge various table fields?

Thanks
Hi there,

Merging tables? Fetching data from various table? Assuming you are talking about fetching data from more then one table, you need to use SQL JOIN, hope it helps. Good luck & Take care.

Expand|Select|Wrap|Line Numbers
  1. SELECT Employees.Name
  2.   FROM Employees, Orders
  3.   WHERE Employees.Employee_ID=Orders.Employee_ID
  4.   AND Orders.Product='Printer' 
  5.  
Dec 4 '06 #2
iburyak
1,017 Expert 512MB
SELECT Field1 + Field2 FROM table_name
Dec 4 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by William Wisnieski | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.