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

Can you maybe give us an example of your input data and desired output? Table structures too if possible.

LOL. I know the feeling.

Good luck.

Oh, that's easy.

SELECT SomeFields FROM SomeTable

WHERE RowID BETWEEN @RowID-2 and @RowID +2

It'll return up to 5 rows. If you don't want the equality condition,...

Sorry, I didn't quite get what you want.

RowID?

I haven't seen that error since I did web dev some years back, but then it was because of the cursortype and lock type. There are some combinations that aren't...