No merge statement. You'll have to write seperate update and insert statements. Something like this

Update table2 set f1 = table1.f2*0.1

FROM table1 where table2.f1=table1.f1 and table1.f1=20

INSERT Into table2 (f1, f2)

SELECT f1,...

Could you maybe post thr structure of you tables, some sample data and an indication of what you're trying to achieve?

As Sergiy said, conditional joins is not somethign that should...

It looks a little wierd, but this is what you want. A not in for 2 fields.

Select table1.* from table1 LEFT OUTER join table2 on table1.f1=table2.f1 and table1.f2=table2.f2

WHERE Table2.f1 is...

Assuming that f1 and f2 are fields in table1 and that the in works the same way in oracle as sql...

Select * from table1 inner join table2 on table1.f1=table2.f1 and...

Probably the easiest is to do the if outside of the query

IF (condition)

 SELECT <fields> from table1 inner join table2 ON...

ELSE

 SELECT <fields> from table1 inner join table3 ON...

Middle of the table? Column order has no meaning in SQL, much like row order. If you wnat columns in a specific order, specify that in the select. The 'order' of...

A log file is often a text file listing events that have occured and the like.

The transaction log for a sQL database is a record of every transaction that has...

I studied just out of books online and the pocket adin's guide. Was all I had.

It's not a hard exam.

I studied for the TS exam using just books online and the pocket admin's guide. Got around 930, first attempt. I haven't seen any of the study guides, but they're...

I think you missed the point I was trying to make. I didn't mean union all, and I know the two queries aren't equal. I said as much

When you write...

Books Online is the title of the help files that come with SQL. They are also available on msdn, but I don't remember the url

Look in the SQL Server group...

I heard a a recent workshop on performance tuning that the query optimiser in SQL 2000 has only one option for optimising an OR, but it has more than one...

Single quotes are string delimiters in SQL. Try

SELECT adi AS Adlar from

OR

Select adi AS "Adlar" from

Hope that helps