Table field merge

[bloukopkoggelmander]

Hi all

Hoping someone can point me in the correct direction.

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

Thanks

[sashi]

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.

SELECT Employees.Name
  FROM Employees, Orders
  WHERE Employees.Employee_ID=Orders.Employee_ID
  AND Orders.Product='Printer' 
 

[iburyak]

SELECT Field1 + Field2 FROM table_name