This is part of trigger and procedure and insert row by row. I don't insert batch of rows to the table. row

Thanks for reply.

I'm used SQL Server 2000.

The table definition is:

CREATE TABLE CustomerSegment

(

Code INT PRIMARY KEY,

rowguidUNIQUEIDENTIFIER DEFAULT(NEWID())

)

CREATE TABLE Person

(

Code INT PRIMARY KEY,

CustomerSegment INT REFERENCES [dbo].[CustomerSegment]([Code]),

rowguidUNIQUEIDENTIFIER DEFAULT(NEWID())

)

CREATE TABLE CustomerCreditD

(

CustomerSegment INT REFERENCES [dbo].[CustomerSegment]([Code]),

rowguidUNIQUEIDENTIFIER PRIMARY KEY DEFAULT(NEWID())

)

CREATE...

Thanks for reply.

This query is the part of a procedure.

I think no different these two query, but output of query 1 is without any row. In other word, "Inner Join...

WendellB (11/12/2012)

---

That helps consisderably. It appears that you really want to sort the display by the Description column then. (It also appears that either Access or SQL Server...

WendellB (11/12/2012)

---

That wasn't my question. What is the file extension of the Access database that contains your data entry form -...

WendellB (11/11/2012)

---

We need some additional information if this query is being used as the data source for a data entry form. First of all, is your database a .adp...

Thank you for reply.

Because I used this query in microsoft access 2003, with order by...