Does merge work with dbf file

[kovvuri.keerthi2]

I created a table in dbf and trying to use the following syntax

MERGE <hint> INTO <table_name>
USING <table_view_or_query>
ON (<condition>)
WHEN MATCHED THEN <update_clause>
WHEN NOT MATCHED THEN <insert_clause>;

my question is does this syntax work in dbf, i am getting following error unrecognized command verb

Thanks,
Keerthi.

[Admin]

This syntax is not a SQL, thats why it doesn't work.

But you can easily merge two of DBF files with SELECT SQL statement. E.g.:

Code: Select all

SELECT * FROM customer AS t1, orders AS t2  WHERE t1.cust_id = t2.cust_id

More information on using the SELECT SQL statement you can find here:
http://dbf-software.com/sql-select.html

[kovvuri.keerthi2]

thank you