I have a sql statement that joins to 4 tables with inner join
and at the last I have where clause. When I execute the statements it runs
the inner join and then applies the where clause on the results.
Is this normal?

I have the following query that runs fine in SQL 2000 but get errors in 2005.
insert into dss_afe_actual_estimate_fact
SELECT     dbo.dss_gl_detail_fact.account_key,
dbo.dss_gl_detail_fact.reference_key,

Hi - Have query structure language question
Hi have two tables,
Table A has a picklist  for a field of limited options - say two, X, Y or Z
Table B 'looks up' to those values, so new entrys, must be either X, Y or Z,