Newbie Question - Go easy

I've read through a number of similar questions in the forum, but because I'
m
so new to SQL Language, I didn't see one that related directly to my attempt
at making mine work.
I'm querying an SMS 2003 database that has self-built entries, etc... by SMS
.
I'm looking to query this db and report back 4 fields Netbios_Name0,
User_Name0, Active0, Obsolete0.
Simple enough...
In the result, if the Netbios_Name0 (machine name) has multiple entries in
the SMS db, these show up and give me much higher numbers than is realistic
to report to Directors, etc...
Ex. If there's really only 100 machines in the db, but because of duplicate
records, it says there's 178.....well, that's not unreliable data to report
back.
I'm looking to result all 4 fields of data as it corresponds to each machine
name, BUT filter out any data (and corresponding data) if the netbios_name0
(machine name) shows up more than once.
So, instead of having:
BobsPC BobWilson Active 1 Obsolete 0
BobsPC BobWilson Active 1 Obsolete 0
It would filter out the duplicate and report back:
BobsPC BobWilson Active 1 Obsolete 0
Here's what I have so far, but I'm still getting errors. Not sure where to
go from here and would certainly appriciate code examples if you wouldn't
mind.
Thx !!!!
ESP
--begin
select distinct
v_R_System.Netbios_Name0,
v_R_System.User_Name0,
v_R_System.Active0,
v_R_System.Obsolete0
from v_R_System
where v_R_System.Active0 = 0
and v_R_System.Obsolete0 = 1
and v_R_System.Netbios_Name0 = (select max (v_R_System.Netbios_Name0 )
from v_R_System
where v_R_System.Netbios_name0 = Netbios_Name0 )
--endI'm not sure what you are trying to accomplish with this part of your query:
and v_R_System.Netbios_Name0 =( select max (v_R_System.Netbios_Name0 ) from
v_R_System where v_R_System.Netbios_name0 = Netbios_Name0 )
Using the MAX aggregrate function on something with a character datatype
will give you the machine that is last in alphabetic order. For example
DECLARE @.foo TABLE (Lastname varchar(50))
INSERT INTO @.foo (Lastname) VALUES ('Johnson')
INSERT INTO @.foo (Lastname) VALUES ('Williams')
SELECT MAX(Lastname) FROM @.foo
would return 'Williams', because it is last in alphabetic order.
Try your query without that last part.
--
"ESP" wrote:

> I've read through a number of similar questions in the forum, but because
I'm
> so new to SQL Language, I didn't see one that related directly to my attem
pt
> at making mine work.
> I'm querying an SMS 2003 database that has self-built entries, etc... by S
MS.
> I'm looking to query this db and report back 4 fields Netbios_Name0,
> User_Name0, Active0, Obsolete0.
> Simple enough...
> In the result, if the Netbios_Name0 (machine name) has multiple entries in
> the SMS db, these show up and give me much higher numbers than is realisti
c
> to report to Directors, etc...
> Ex. If there's really only 100 machines in the db, but because of duplicat
e
> records, it says there's 178.....well, that's not unreliable data to repo
rt
> back.
> I'm looking to result all 4 fields of data as it corresponds to each machi
ne
> name, BUT filter out any data (and corresponding data) if the netbios_name
0
> (machine name) shows up more than once.
> So, instead of having:
> BobsPC BobWilson Active 1 Obsolete 0
> BobsPC BobWilson Active 1 Obsolete 0
> It would filter out the duplicate and report back:
> BobsPC BobWilson Active 1 Obsolete 0
> Here's what I have so far, but I'm still getting errors. Not sure where to
> go from here and would certainly appriciate code examples if you wouldn't
> mind.
> Thx !!!!
> ESP
> --begin
> select distinct
> v_R_System.Netbios_Name0,
> v_R_System.User_Name0,
> v_R_System.Active0,
> v_R_System.Obsolete0
> from v_R_System
> where v_R_System.Active0 = 0
> and v_R_System.Obsolete0 = 1
> and v_R_System.Netbios_Name0 = (select max (v_R_System.Netbios_Name0 )
> from v_R_System
> where v_R_System.Netbios_name0 = Netbios_Name0 )
> --end
>|||I don't say anything syntactically wrong with your statement.
select distinct
max(v_R_System.Netbios_Name0),
v_R_System.User_Name0,
v_R_System.Active0,
v_R_System.Obsolete0
from v_R_System
where v_R_System.Active0 = 0
and v_R_System.Obsolete0 = 1
group by v_R_System.User_Name0,
v_R_System.Active0,
v_R_System.Obsolete0
Will this do what you are looking for?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"ESP" <ESP@.discussions.microsoft.com> wrote in message
news:E8FCAD16-5D0F-46D7-A419-5CA42F20BA33@.microsoft.com...
> I've read through a number of similar questions in the forum, but because
> I'm
> so new to SQL Language, I didn't see one that related directly to my
> attempt
> at making mine work.
> I'm querying an SMS 2003 database that has self-built entries, etc... by
> SMS.
> I'm looking to query this db and report back 4 fields Netbios_Name0,
> User_Name0, Active0, Obsolete0.
> Simple enough...
> In the result, if the Netbios_Name0 (machine name) has multiple entries in
> the SMS db, these show up and give me much higher numbers than is
> realistic
> to report to Directors, etc...
> Ex. If there's really only 100 machines in the db, but because of
> duplicate
> records, it says there's 178.....well, that's not unreliable data to
> report
> back.
> I'm looking to result all 4 fields of data as it corresponds to each
> machine
> name, BUT filter out any data (and corresponding data) if the
> netbios_name0
> (machine name) shows up more than once.
> So, instead of having:
> BobsPC BobWilson Active 1 Obsolete 0
> BobsPC BobWilson Active 1 Obsolete 0
> It would filter out the duplicate and report back:
> BobsPC BobWilson Active 1 Obsolete 0
> Here's what I have so far, but I'm still getting errors. Not sure where to
> go from here and would certainly appriciate code examples if you wouldn't
> mind.
> Thx !!!!
> ESP
> --begin
> select distinct
> v_R_System.Netbios_Name0,
> v_R_System.User_Name0,
> v_R_System.Active0,
> v_R_System.Obsolete0
> from v_R_System
> where v_R_System.Active0 = 0
> and v_R_System.Obsolete0 = 1
> and v_R_System.Netbios_Name0 = (select max (v_R_System.Netbios_Name0 )
> from v_R_System
> where v_R_System.Netbios_name0 = Netbios_Name0 )
> --end
>|||Thank you very much for your responses. Although both examples do return
results, there are still duplicate results of the same thing.
Goal:
Instead of having this as a result:
BobsPC BobWilson Active 1 Obsolete 0
BobsPC BobWilson Active 1 Obsolete 0
It would filter out the duplicate and report back this result:
BobsPC BobWilson Active 1 Obsolete 0
Thx !!!!!
ESP
p.s. My alias is ESP, but my name is Mark Williams as well
"Louis Davidson" wrote:

> I don't say anything syntactically wrong with your statement.
> select distinct
> max(v_R_System.Netbios_Name0),
> v_R_System.User_Name0,
> v_R_System.Active0,
> v_R_System.Obsolete0
> from v_R_System
> where v_R_System.Active0 = 0
> and v_R_System.Obsolete0 = 1
> group by v_R_System.User_Name0,
> v_R_System.Active0,
> v_R_System.Obsolete0
> Will this do what you are looking for?
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often convincing.
"
> (Oscar Wilde)
> "ESP" <ESP@.discussions.microsoft.com> wrote in message
> news:E8FCAD16-5D0F-46D7-A419-5CA42F20BA33@.microsoft.com...
>
>|||Can you post some sample data and the query that gives the invalid results?
I don't know how this is possible, and it is too hard to guess without
seeing data.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"ESP" <ESP@.discussions.microsoft.com> wrote in message
news:308CD777-66CA-46FC-AF8F-D8655D2DDDC9@.microsoft.com...
> Thank you very much for your responses. Although both examples do return
> results, there are still duplicate results of the same thing.
> Goal:
> Instead of having this as a result:
> BobsPC BobWilson Active 1 Obsolete 0
> BobsPC BobWilson Active 1 Obsolete 0
> It would filter out the duplicate and report back this result:
> BobsPC BobWilson Active 1 Obsolete 0
>
> Thx !!!!!
> ESP
> p.s. My alias is ESP, but my name is Mark Williams as well
>
>
> "Louis Davidson" wrote:
>

Newbie query question

I need to include data from a table which is not directly related to
the "hub" table, and am kinda stuck.
I doubted it would work (tried anyhow), but this is the code from my
attempt:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.Consig nmentCode)
LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
AND Reserve.InvoiceId=Invoice.InvoiceId
You can see why it did didn't work, and hopefully, what I am trying to
do.
I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
relate to "Stockline".
If I try to base all my relationships on "Resreve", then I end up with
ths same problem for "Part".
What's my next step?
-Mo
On Feb 22, 2:41Xpm, Lucas Kartawidjaja
<LucasKartawidj...@.discussions.microsoft.com> wrote:
> Without knowing the table structure and their relationship, I would suggest
> try the following query or something close:
> SELECT
> X X X X ConsignmentCodes.CodeDesc,
> X X X X Stockline.ConsignmentCode,
> X X X X Reserve.SalesOrderId,
> X X X X Invoice.ShipDate,
> X X X X Part.Number,
> X X X X Reserve.Shipped as Qty,
> X X X X SOItem.UnitAmount,
> X X X X (Reserve.Shipped*SOItem.UnitAmount) as Total,
> X X X X 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM X XStockline LEFT OUTER JOIN Part ON (Stockline.PartId=Part.PartId)
> X X X X LEFT OUTER JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
> X X X X LEFT OUTER JOIN ConsignmentCodes ON
> X X X X X X X X (Stockline.ConsignmentCode=ConsignmentCodes.Consig nmentCode)
> X X X X LEFT OUTER JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
> X X X X LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=Invoice..SalesOrderId)
> X X X X AND (Reserve.InvoiceId=Invoice.InvoiceId)
> Lucas
>
> "Mehile.Orl...@.gmail.com" wrote:
>
>
>
> - Show quoted text -
Thanks, I think that gets me going again.
If I run into anything else, I'll repost.
Mo
sql

Newbie query question

I need to include data from a table which is not directly related to
the "hub" table, and am kinda stuck.
I doubted it would work (tried anyhow), but this is the code from my
attempt:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
AND Reserve.InvoiceId=Invoice.InvoiceId
You can see why it did didn't work, and hopefully, what I am trying to
do.
I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
relate to "Stockline".
If I try to base all my relationships on "Resreve", then I end up with
ths same problem for "Part".
What's my next step?
-MoWithout knowing the table structure and their relationship, I would suggest
try the following query or something close:
SELECT
ConsignmentCodes.CodeDesc,
Stockline.ConsignmentCode,
Reserve.SalesOrderId,
Invoice.ShipDate,
Part.Number,
Reserve.Shipped as Qty,
SOItem.UnitAmount,
(Reserve.Shipped*SOItem.UnitAmount) as Total,
1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
FROM Stockline LEFT OUTER JOIN Part ON (Stockline.PartId=Part.PartId)
LEFT OUTER JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
LEFT OUTER JOIN ConsignmentCodes ON
(Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
LEFT OUTER JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=Invoice.SalesOrderId)
AND (Reserve.InvoiceId=Invoice.InvoiceId)
Lucas
"Mehile.Orloff@.gmail.com" wrote:
> I need to include data from a table which is not directly related to
> the "hub" table, and am kinda stuck.
> I doubted it would work (tried anyhow), but this is the code from my
> attempt:
> SELECT
> ConsignmentCodes.CodeDesc,
> Stockline.ConsignmentCode,
> Reserve.SalesOrderId,
> Invoice.ShipDate,
> Part.Number,
> Reserve.Shipped as Qty,
> SOItem.UnitAmount,
> (Reserve.Shipped*SOItem.UnitAmount) as Total,
> 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM Stockline JOIN Part ON (Stockline.PartId=Part.PartId)
> LEFT JOIN Reserve ON (Stockline.StockId=Reserve.StockId)
> LEFT JOIN ConsignmentCodes ON
> (Stockline.ConsignmentCode=ConsignmentCodes.ConsignmentCode)
> LEFT JOIN SOItem ON (Stockline.PartId=SOItem.PartId)
> WHERE Reserve.SalesOrderId=Invoice.SalesOrderId
> AND Reserve.InvoiceId=Invoice.InvoiceId
> You can see why it did didn't work, and hopefully, what I am trying to
> do.
> I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
> relate to "Stockline".
> If I try to base all my relationships on "Resreve", then I end up with
> ths same problem for "Part".
>
> What's my next step?
> -Mo
>|||On Feb 22, 2:41=A0pm, Lucas Kartawidjaja
<LucasKartawidj...@.discussions.microsoft.com> wrote:
> Without knowing the table structure and their relationship, I would sugges=t
> try the following query or something close:
> SELECT
> =A0 =A0 =A0 =A0 ConsignmentCodes.CodeDesc,
> =A0 =A0 =A0 =A0 Stockline.ConsignmentCode,
> =A0 =A0 =A0 =A0 Reserve.SalesOrderId,
> =A0 =A0 =A0 =A0 Invoice.ShipDate,
> =A0 =A0 =A0 =A0 Part.Number,
> =A0 =A0 =A0 =A0 Reserve.Shipped as Qty,
> =A0 =A0 =A0 =A0 SOItem.UnitAmount,
> =A0 =A0 =A0 =A0 (Reserve.Shipped*SOItem.UnitAmount) as Total,
> =A0 =A0 =A0 =A0 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> FROM =A0 =A0Stockline LEFT OUTER JOIN Part ON (Stockline.PartId=3DPart.Par=tId)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN Reserve ON (Stockline.StockId=3DReserve.St=ockId)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN ConsignmentCodes ON
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 (Stockline.ConsignmentCode=3DConsignmentCo=des.ConsignmentCode)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN SOItem ON (Stockline.PartId=3DSOItem.PartI=d)
> =A0 =A0 =A0 =A0 LEFT OUTER JOIN Invoice ON (Reserve.SalesOrderId=3DInvoice=.SalesOrderId)
> =A0 =A0 =A0 =A0 AND (Reserve.InvoiceId=3DInvoice.InvoiceId)
> Lucas
>
> "Mehile.Orl...@.gmail.com" wrote:
> > I need to include data from a table which is not directly related to
> > the "hub" table, and am kinda stuck.
> > I doubted it would work (tried anyhow), but this is the code from my
> > attempt:
> > SELECT
> > ConsignmentCodes.CodeDesc,
> > Stockline.ConsignmentCode,
> > Reserve.SalesOrderId,
> > Invoice.ShipDate,
> > Part.Number,
> > Reserve.Shipped as Qty,
> > SOItem.UnitAmount,
> > (Reserve.Shipped*SOItem.UnitAmount) as Total,
> > 1-(ConsignmentCodes.CodeCommRate*.01) as ConsignorPercent
> > FROM Stockline JOIN Part ON (Stockline.PartId=3DPart.PartId)
> > LEFT JOIN Reserve ON (Stockline.StockId=3DReserve.StockId)
> > LEFT JOIN ConsignmentCodes ON
> > (Stockline.ConsignmentCode=3DConsignmentCodes.ConsignmentCode)
> > LEFT JOIN SOItem ON (Stockline.PartId=3DSOItem.PartId)
> > WHERE Reserve.SalesOrderId=3DInvoice.SalesOrderId
> > AND Reserve.InvoiceId=3DInvoice.InvoiceId
> > You can see why it did didn't work, and hopefully, what I am trying to
> > do.
> > I need "Invoice.ShipDate", but "Invoice" doesn't have any fields which
> > relate to "Stockline".
> > If I try to base all my relationships on "Resreve", then I end up with
> > ths same problem for "Part".
> > What's my next step?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks, I think that gets me going again.
If I run into anything else, I'll repost.
Mo

Newb question

I am attempting to retrieve specific task related data from a Project server
environment for input to an Excel 2003 spreadsheet and have created the
following SQL view using:
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS CROSS JOIN
dbo.MSP_TASKS
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
My logic here is that this query will pull back all tasks that are
milestones from 'project 92' only. However, this query pulls back all
milestones from all projects... I have no idea why, could someone please
shed some light on this newb.
Many thanks,
Nock (SQL Newb, Australia)I think the CROSS JOIN might be a clue. I would just use a JOIN
"Nock" wrote:

> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
MSP_TASKS tables. A cross join between two tables produces what is known as
a
Cartesian product, which is a table that contains all of the possible
combinations between the rows between the input tables. In other words, a
cross join between two tables X and Y with x and y rows respectively will
contain 1 row for each y rows for each row in X, for a total of x times y
rows.
What you probably want is something like this
SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_TASKS.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS INNER JOIN
dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
dbo.MSP_TASKS.PROJ_ID
WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
(dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
"Nock" wrote:

> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Nock,
What is the common column between the tables? n other words, does MSP_TASKS
have a foreign Key column to the Primary Key column on MSP_PROJECTS, or
vice-versa.
Whichever is the key column you should then use a standard JOIN statement.
If you want just the Tasks that are associated with Project 92, then you
should use the following...
SELECT proj.PROJ_NAME,
task.TASK_NAME,
task.TASK_IS_MILESTONE
FROM dbo.MSP_PROJECTS proj LEFT JOIN
dbo.MSP_TASKS task ON proj.{PK} = task.{FK}
WHERE (proj.PROJ_ID = 92)
AND (task.TASK_IS_MILESTONE = 1)
The LEFT Join will ensure you get all Project Data back together with any
Task data that is relevent, or NULL values if none present. If you use INNER
join then there will need to be at least one reacord in each table.
Enjoy,
"Nock" wrote:

> I am attempting to retrieve specific task related data from a Project serv
er
> environment for input to an Excel 2003 spreadsheet and have created the
> following SQL view using:
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS CROSS JOIN
> dbo.MSP_TASKS
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> My logic here is that this query will pull back all tasks that are
> milestones from 'project 92' only. However, this query pulls back all
> milestones from all projects... I have no idea why, could someone please
> shed some light on this newb.
> Many thanks,
> Nock (SQL Newb, Australia)|||Thanks Mark et al, much appreciated and great explanation.
I'm in one of those situations where I've been asked to become a 'SQL
person' in a day...
Loving life :)
Cheers,
Nock
"Mark Williams" wrote:
> it is because of the CROSS JOIN used to connect the MSP_PROJECTS and
> MSP_TASKS tables. A cross join between two tables produces what is known a
s a
> Cartesian product, which is a table that contains all of the possible
> combinations between the rows between the input tables. In other words, a
> cross join between two tables X and Y with x and y rows respectively will
> contain 1 row for each y rows for each row in X, for a total of x times y
> rows.
> What you probably want is something like this
> SELECT dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_NAME,
> dbo.MSP_TASKS.TASK_IS_MILESTONE
> FROM dbo.MSP_PROJECTS INNER JOIN
> dbo.MSP_TASKS ON dbo.MSP_PROJECTS.PROJ_ID =
> dbo.MSP_TASKS.PROJ_ID
> WHERE (dbo.MSP_PROJECTS.PROJ_ID = 92) AND
> (dbo.MSP_TASKS.TASK_IS_MILESTONE = 1)
> --
> "Nock" wrote:
>|||Try these sites for a general SQL overview...
http://www.w3schools.com/sql/sql_intro.asp
http://sqlzoo.net/
"Nock" <Nock@.discussions.microsoft.com> wrote in message
news:05979A9F-A3BC-401B-867F-CDC7114D2CE1@.microsoft.com...
> Thanks Mark et al, much appreciated and great explanation.
> I'm in one of those situations where I've been asked to become a 'SQL
> person' in a day...
> Loving life :)
> Cheers,
> Nock
> "Mark Williams" wrote:
>
as a
a
will
y
server
the
please