SQL Kiwi (5/24/2012)

---

If this is classic ADO, you won't be able...

SGT_squeequal (5/24/2012)

---

When you say that when you run your select statement the rows are inconsistant in SQL do you mean after inserting say 100 rows and then running your select...

Yes that works perfect! Thanks.

Thanks SSCommitted and Jared. Both methods are useful to my understanding of SQL Server and workable. Thanks again.

Here you go.

USE Master

GO

CREATE DATABASE JoinTest;

GO

USE JoinTest;

GO

CREATE TABLE Customers

(

CustomerName varchar(50),

Addr varchar(50),

City varchar(50)

);

CREATE TABLE Products

(

ProductName varchar(50),

Descr varchar(50),

Price money

);

CREATE TABLE Sales

(

SaleDate datetime,

ProductName varchar(50),

CustomerName varchar(50),

Quantity int

);

GO

INSERT INTO Customers VALUES ('Ken', '123 Elm...